Vlookup function in Alteryx

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!

Alteryx Screenshot.xlsx

Workflow

Accepted answers

DataNath

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.

All comments

DataNath

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. 🙂

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167