Find Replace Not Working

Hello,

I am having trouble getting the find replace tool to work. The objective in my workflow is to change the Fair Value levels in my main dataset based of the specific asset types. I looked at previous threads regarding issues with this tool - such as changing the data type to string using the select tool, however this has not solved my problem.

Any suggestions are helpful, please see attached a sample workflow.

Thanks!

Sample_FindReplace.yxmd

Workflow

Developer

Designer Cloud

Output

Data Investigation

Accepted answers

Dina

I think for your purpose, it should be "Append Fields" rather than "Replace Found Text with Value"

Sample_FindReplace - DR.yxmc

binu_acs

@jyeung753 Your find and replace texts are not matching, that's why you are not getting any result

All comments

Dina

Do you mind share your sample data?

jyeung753

Apologies - yes here is the sample data. Thank you

Sample_Data1.xlsx

Dina

I think for your purpose, it should be "Append Fields" rather than "Replace Found Text with Value"

Sample_FindReplace - DR.yxmc

binu_acs

@jyeung753 Your find and replace texts are not matching, that's why you are not getting any result

jyeung753

Yup that works, it seemed to run correctly as well once I fixed the configuration to also had InvestmentTypeCode in the Find Value window, rather than Fair Value. Thank you for the help!

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335