Skip to main content
Question

Create a table with all possible pairings of numeric values from input table.


gcarmich
Participant
Forum|alt.badge.img+1

 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?

ebygomm
Influencer
Forum|alt.badge.img+32
  • Influencer
  • January 21, 2021

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

CaptureIf you want all combinations you can do this

 

CaptureThis wouldn't include matching each number with itself though, so you would need to handle those separately


gcarmich
Participant
Forum|alt.badge.img+1
  • Participant
  • January 21, 2021

Success! Thank you!


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings