Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Create all combinations of concatenated elements of one column

Robinvm
8 - Asteroid

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.

 

Table.PNG

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

Text_to_columns.PNG

 

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:

Empl_wf.PNG

After the crosstab I had following table.

Crosstab.PNG

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!

8 REPLIES 8
PhilipMannering
16 - Nebula
16 - Nebula

Hi @Robinvm 

 

Perhaps like this?

PhilipMannering_0-1648921924187.png

 

Robinvm
8 - Asteroid

Hey @PhilipMannering,

 

thank you for your answer. :)

 

This solution is very static. 

 

For example, if I would use this as input:

Table2.PNG

I would like to have following as output:

 

solution_table2.PNG

 

Do you have any further ideas? 

 

Thank you for your help!

PhilipMannering
16 - Nebula
16 - Nebula

Point taken.

 

This should be less static,

PhilipMannering_0-1648980563919.png

 

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

 

Robinvm
8 - Asteroid

Brilliant! @PhilipMannering!

 

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

Qiu
20 - Arcturus
20 - Arcturus

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

Robinvm
8 - Asteroid

@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
16 - Nebula
16 - Nebula

@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
8 - Asteroid

@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 :) 

Labels