I have officially given up on trying to do this in excel so want to try it in Alteryx, which I'm more confident can do this but I don't even know how to begin. I have 1 spreadsheet with a field of unique alphanumeric items (column A) and I have a separate spreadsheet with unique alphanumeric items (column B.) I want to find all fields in B:B that contain the text in A4,A5, A6, etc. Please see example below. Any guidance appreciated.
Solved! Go to Solution.
@danniemme check out the Find & Replace tool!
Why does IA1000 get assigned to IA789?
that was a typo of mine in example, intended to put IA7891000
Thank you @JosephSerpis! This does also work and gets closer to my end output but it does take longer than using find/replace when using in real life m due to the field size of the actual datasets at the end of the day (10's of thousands x 10's of thousands.) Thank you for this though, these are two tools I do not commonly use and there's always more than one way to skin a cat so-to-speak!