Hello,
I was looking around the community here for a solution to see if someone encountered something similar. I see it in bits and parts but not the entirety and I was hoping someone could help 🙂
I am pretty new to using Alteryx and have been taking the training courses but need some assistance on an Ask, please:
What I Have:
What I Need:
What I Tried:
Two files of "Input Data." --> Join (to see what matched in one column) --> Output Data
Two files of "Input Data." --> Formula (to concatenate; To Combine the data to try and see what matched in multiple columns) --> Output Data
I'm about to try the coding/formula needed to search by hierarchy (if, and) in Alteryx.
Is there a smoother way of combining all of that to transform it into one straight workflow?
I appreciate your help!
Solved! Go to Solution.
Hi @MannyNay,
You were on the right track with using the Join tool. The initial Join compares Columns X, Y, and Z at the same time. The subsequent Join tools take the unmatched outputs from the previous Join tool and match Column X, then Column Y, then Column Z. Finally the information is grouped, tagged with a sheet name field, then Output to a single Excel file. You may need to make some minor adjustments for your actual data. Let me know if you have questions.
Hi T_Willins,
Your Workflow and detailed breakdown was such a great help! Thank you for helping guide me in the right direction. Seeing your Workflow, it makes sense, especially the use of the Union tools.