Alteryx Designer Desktop Discussions

bharathss · ‎03-17-2023

Hey Guys,

Have data in the following form:

I want the final output to just be unique combinations -

Any help here is appreciated.

Thanks!

ShankerV · ‎03-17-2023

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

DataNath · ‎03-17-2023

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:

gaoa · ‎03-17-2023

Hi @bharathss my solution (similar to solution 1):

Unique Combinations