I have a .csv table with 35 numeric values in increments of 5 (5, 10, 15,..). I need to create a table that list all possible unique pairings of these values in two columns ((5,5), (5,10), (5,15),...) . I've tried joiners, mergers, and combiners but can't get the output I need. Is there a transformer that would do this?
Page 1 / 1
Does order matter? i.e can you have (5,10) and (10,5)?
If you want all permutations including matching each number with itself you can do this
If you want all combinations you can do this
This wouldn't include matching each number with itself though, so you would need to handle those separately
Success! Thank you!