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

[lego3]

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 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

[lego3]

Hi RolandSchubert,

thanks for your solution. It solved my porblem. I've added a filter to sort out the pairs.

Kind regards,

Mat