I have two sets of data.
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?
Solved! Go to Solution.
Possible to share sample data and output?
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.
Is there a separate file for mapping of these two data sets ?
Or any key ?
Thank you!