Vlookup function in Alteryx

[AmarKB80]

 I am currently practicing the VLOOKUP function in Alteryx using the 'Find Replace' tool to look up region names for cost centers from SAP data. However, I encountered an issue where I am unable to see the Cost Center field in the Find section for selection. I have attached a screenshot of the Find section for your reference.

Could anyone please assist me in resolving this issue so that I can view and select the required field?

Thank you for your help!

[DataNath · Accepted solution]

Hi @AmarKB80, without seeing your data, I'm guessing your Cost Center field is a numeric data type? If so, Find Replace works on strings so you'll need to make this a string by placing a Select tool beforehand.

[nagakavyasri]

@AmarKB80 Only String fields show for Find field, try changing the datatype to string and try.

[AmarKB80]

Thank you so much. It worked. 🙂

[AmarKB80]

Thank you @DataNath.. it worked. 🙂