FIND REPLACE FUNCTION FOR NUMBERS

[aamerin]

I have two sets of data.

• Table one is a database of verified bar code numbers
• Table two is a list of bar codes that a client has sent (however, the numbers may be incorrect or incomplete)

What I would like to do is is write a version of find/replace function that says, if you find any part of "this bar code" from table two in table one, append the found bar code from table one.

I've tried the find/replace tool, but it seems to work mostly on text. I need something that can do this for numbers (or maybe I just need to understand the find/replace better).

Can someone help me out?

[ponraj]

Possible to share sample data and output?

[aamerin]

Here's an example spreadsheet.

Tab #1 is the database of confirmed bar codes that exist

Tab #2 is the list of barcodes that a client has submitted to me

Tab #3 is how I would like Alteryx to output. Find any barcodes that contain any part of the submission, and output the confirmed barcode out to the right.

[aish49]

Is there a separate file for mapping of these two data sets ?

Or any key ?

[ponraj · Accepted solution]

Here is the sample workflow.  Hope this is helpful. You just need to convert numbers into string while comparing them. 

[aamerin]

Thank you!