Matching pairs by one ID and creat/manipulte a second ID / serial number

Question

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

RolandSchubert · Accepted Answer

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