List of all combinations

[olehr]

Hi,

I have an issue

What I would like to do is to create a list of all possible combinations, but I have no clue on where to begin. 

The list should look like the list below.

All inputs are appreciated 

Thanks

Ole Henrik

[BenMoss]

I think the solution people will provide depnds on whether you want the solution to be dynamic or not.

A quick fix for this type of problem is to create a summerize stream for each field with that field specified as a group by clause.

You can then append those 5 streams together using the append fields tool which will give you your desired output.

Ben

[jdunkerley79 · Accepted solution]

As @BenMoss says there are various ways to do this.

My approach is to enumerate all the possible values and then join them back together.

First count number of options for each field

Then product this to make total number of possible combinations

Using a generate rows you can create this set of scenarios and then join it all back together

[olehr]

Thank you so much. That helped :)

[polonius11]

This is great; thank you for sharing; adopted it for a flow I am working!

[Mike_Transferpricing]

This is extremely helpful!