Generate rows with condition

[marymgimenez]

Hello,

I’m trying to create a table dynamically to list unique combinations of two columns. In the sample below, there are two identifier columns, X & Y. I need the unique combinations of X & Y regardless if the value is interchanged in both columns. In the table below, Row 1 and 3 are similar because both have ‘AA’ and ‘BB’ values. I only want to keep one record from these two.

Source Table:

Row #	X	Y	Combination (X + Y)	Reverse (Y + X)
1	AA	BB	AABB	BBAA
2	AA	CC	AACC	CCAA
3	BB	AA	BBAA	AABB
4	BB	DD	BBDD	DDBB

The output table will list only the following. Row 3 was removed since the values are similar to Row 1.

Row #	X	Y	Combination (X + Y)	Reverse (Y + X)
1	AA	BB	AABB	BBAA
2	AA	CC	AACC	CCAA
4	BB	DD	BBDD	DDBB

Which tool is best to accomplish this in Alteryx? I tried to use Generate Rows but couldn't make it work. Thank you!

[DavidP · Accepted solution]

My preferred method would be to transpose the Combination and Reverse, then use a Unique tool to remove the dups and CrossTab back

[RobertOdera · Accepted solution]

Hi, @marymgimenez 

Try this.

Please mark as a solution + like, if it works for you.

Dynamic set up plus uses ReverseString() formula.

Stepped though it to show you how that works.

The workflow is attached.

Cheers!

[marymgimenez]

Thank you so much for the quick response! This helps a lot. Appreciate your help!

[RobertOdera]

@marymgimenez 

You're most welcome!

Cheers.