Calling all Alteryx customers: Refer your colleague to try Alteryx and receive a $50 gift card. Sign up now!
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

Multi Column Match

mallieteal21
7 - Meteor
‎11-21-2023 09:22 AM

I have two data sets - one with a list of all the names I am looking for (Sheet LookingFor) and the other contains a list of file paths (sheet ALLDWG). I'm trying to match the names in LookingFor to the file paths in ALLDWG to see how many file paths contain those names. Ultimately I want to match each line item on the looking for sheet to the list of file paths on the ALLDWG sheet. Can anyone the best approach? I started to parse the text but not sure that is the best method. I've also attached a copy of what I want the final results to look like - these were gathered manually in excel. Any help is greatly appreciated! 

Preview file
619 KB
Preview file
15 KB
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
CoG
14 - Magnetar
‎11-21-2023 09:54 AM

Here's a Batch Macro that I believe accomplishes you're stated goal.

Screenshot 1.png

Screenshot 2.png

Just be aware that it can take some time to run (~30 seconds on my machine with provided data) due to the large number of comparisons required.

Sample Workflow.yxzp
Reply
0 Likes
mallieteal21
7 - Meteor
‎11-21-2023 10:09 AM

Thank you so much!! This is exactly what I needed. 

Reply
0 Likes
register for inspire
inspire session catalog
Labels
Top Solution Authors
View All