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!
