Find Replace Not Working

[jyeung753]

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!

[Dina]

Do you mind share your sample data?

[jyeung753]

Apologies - yes here is the sample data. Thank you 

[Dina · Accepted solution]

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

[binuacs · Accepted solution]

@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!