Henry_2

Combine value lists, all combinations

Discussion created by Henry_2 on Mar 27, 2017
Latest reply on Apr 2, 2017 by user19752

Hi,

 

When having three value lists, eg.:

List1,     List2,     List3
----       ----       ----
A          Z1          001
B          Z2          002
           Z3         

         

I'm struggling how to create a value list containing all combinations:

A,Z1,001

A,Z1,002

A,Z2,001

A,Z2,002

A,Z3,001

A,Z3,002

B,Z1,001

B,Z1,002

B,Z2,001

B,Z2,002

B,Z3,001

B,Z3,002

 

(the comma could be any delimiter)

 

I likely can create it by using a loop on List1, with nested loops for List2 and List3. That feels like I'm using a lot of script steps for something that is likely possible to solve with just a few steps.

 

Anyone with an idea how to solve this with less script steps?

Outcomes