Hello,
I'm struggeling to find a soltuin in Alteryx for the following challange:
The Input data has different ID's / serial numbers and I would like to match them to pairs of two by ID-1 and change the ID-2 so that it is the same (either keep one of the two ID-1 or create a new one and replace the original ID with the new ID-2).
Source Table
Target Table
Any ideas? I've tried multi-row formula but I didn't succeed.
Thanks
Mat
Solved! Go to Solution.
Hi @lego3 ,
my approach would be to select the first ID-2 for each ID-1 using a Summarize tool, join the result to the original data and set [ID-2] = [First ID-2]. I've attached a sample workflow. What do you think?
Best,
Roland