Find and Replace Tool Not Showing All Options?

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!

Datasets

Designer Cloud

Help

Accepted answers

DataNath

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.

All comments

DataNath

binu_acs

@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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703