Generate All Row Combinations

data4accounting

Hi All- 

I don't know if I'm just over thinking this at this point but I'm struggling to find the solution. I have seen a lot on the topic of generating combinations of columns but I have not been able to find anything discussing generating all combination of rows. 

Please see attached photos of input and desired output. Thanks!!

Alteryx Combo Help.PNG

Gawa

hi @data4accounting 

If you always have a fixed number of columns, you just have to put Select tools in parallel, and cross-join them one by one by Appendix Filed tool.

But, if the number of columns dynamically changes depending on input files, you have to use Iterative Macro like this. This WF involves some advanced technique like, Iterative Macro, Dynamic Rename...if you have time, please look into it to understand how it works.

Please note that cross-join operation is in general 'costly' operation, and that might generate uncountable records over millions. Please be careful.

1235792_gawa.yxzp