We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and
join in on the fun here.
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
Hi @bharathss
1. Use Record ID tool.
2. Split the dataset into 2 using select tool with Record ID and Feild1 in dataet1.
Dataset2 -> Record ID and Field2
3. Use append fields tool
4. Use the filter tool, [Source_RecordID] >= [RecordID]
5. Select tool to drop the unwanted columns.
You get the desired output.
Many thanks
Shanker V
Hey @bharathss, I believe this gets you what you're after - combos are there but superheroes may be in the opposite column to your example:
