Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Return all, multiple results in a field that contain text from another field

Highlighted
7 - Meteor

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.capture2.png

Highlighted
Alteryx Certified Partner

@danniemme check out the Find & Replace tool!

1.PNG

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @danniemme I mocked up a workflow let me know what you think?

 

Contains_19022020.JPG

Highlighted
Alteryx Certified Partner

Why does IA1000 get assigned to IA789?

Highlighted
Alteryx
Alteryx

This is pretty close to your output. I don't understand why IA1000 matched to IA789 in your example. Am I missing something?

Highlighted
7 - Meteor

that was a typo of mine in example, intended to put IA7891000

Highlighted
7 - Meteor

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!

Labels