Unique Combinations

Question

Hey Guys,

Have data in the following form:

Field 1Field 2ThorThorHulkHulkCaptain AmericaCaptain AmericaBatmanBatmanSupermanSupermanFlashFlash

I want the final output to just be unique combinations -

Field 1Field 2ThorBatmanThorSupermanThorFlashThorThorThorHulkThorCaptain AmericaHulkBatmanHulkSupermanHulkFlashHulkHulkHulkCaptain AmericaCaptain AmericaBatmanCaptain AmericaSupermanCaptain AmericaFlashCaptain AmericaCaptain AmericaBatmanBatmanBatmanSupermanBatmanFlashSupermanSupermanSupermanFlashFlashFlash

Any help here is appreciated.

Thanks!

gaoa · Answer

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

Unique Combinations.yxmd

DataNath · Answer

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:

Unique superhero combos.yxmd

ShankerV · Answer

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