Create all combinations of concatenated elements of one column

[Robinvm]

Hey Community,

I am trying to create a list of all combinations for a specific weekly challenge.

You have two columns and an unknown number of rows.

 

I would like to create all combinations of "Concat_Right_Value" rowwise like this:

I tried different ways to solve it ( using Iteration Macros, Text to column tools and append tools) but nothing really helped.

A basic approach of me of this Workflow:

After the crosstab I had following table.

 

Now I could two times split to rows and I have the desired solution. But How I could to do this for an unknown number of rows?

Thanks in advance!

 

 

[PhilipMannering]

Hi @Robinvm 

Perhaps like this?

[Robinvm]

Hey @PhilipMannering,

thank you for your answer. :)

This solution is very static. 

For example, if I would use this as input:

 

I would like to have following as output:

Do you have any further ideas? 

Thank you for your help!

[PhilipMannering · Accepted solution]

Point taken.

This should be less static,

I leave it to you to rename the columns. Beyond this, I have a few further ideas.

[Robinvm]

Brilliant! @PhilipMannering!

You are a Hero, Thank you very much! :)

[Qiu]

@Robinvm 
I am curions which weekly challenge? 😊
@PhilipMannering 
Nice one on the two solutions.

[Robinvm]

@Qiu Challenge 200

The task requires to solve two sodokus. (Intermediate and difficult.)

I want to create a macro that solves every sodoku that is solveable.

Maybe I am thinking to complicated, but I wanted to use the Brute-Force-method to solve it. Therefore I need all possible combinations to try them out :D

[PhilipMannering]

@Robinvm You know you can download other peoples solutions from that Weekly Challenge? I can't remember doing it....might have used the Python Tool.

[Robinvm]

@PhilipMannering I know, but I would like to solve it like a "real-world problem". And there are also no solutions :D 

Furthermore I think asking questions to more experienced Alteryx users, like you for example, and to be interactive with the community helps much more to

understand the secrets of Alteryx :)