Find and Replace Tool Not Showing All Options?

[dmpope]

Hi there,

I'm not sure if this an issue with the spreadsheet or my configurations. But I have a set of BIN Numbers in my data that I need to find on my VLOOKUP spreadsheet and add a column with it's corresponding bank. Below is an example of my replace table/spreadsheet, my data I'm searching, and the output that I need:

I have the data set in the "Find" anchor and the Replace table linked to the "Replace" anchor. In the configuration window, I set "Find within Field" to the BIN column. But the "Find Value" is only showing Currency and Bank option. I suppose I'm confused since I need to match the BIN numbers between both sheets and append the Bank number to my data. Can anyone help on what I need to fix?

Thank you!

[DataNath · Accepted solution]

Have you checked whether or not the [BIN] field is numeric in your lookup table (the input with Currency/Bank)? If you haven't done any conversion then Alteryx will read this in as numeric based on the example above. It'll need to be a string data type if so.

[binuacs]

@dmpope in your Data Example make sure the field 'BIN' is string. Find Replace only allow string fields

[dmpope]

Thank you both! I didn't realize it needed to be a string value. All good now :)