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

Concatenation

sriniprad08
11 - Bolide

Hi Team,

 

I need help. I have two columns. I need all the permutation combination of them. 

Please find attached the input and potential output.

 

Thank you.

 

sriniprad08_0-1609937281471.png

 

sriniprad08_1-1609937298959.png

 

 

9 REPLIES 9
Kenda
16 - Nebula
16 - Nebula

Hi @sriniprad08 

 

This is similar to a weekly challenge that was done in the past. Take a look at the below linked post to see if that gets you going in the right direction. 

 

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-231-What-a-Combo/td-p/626971 

Qiu
20 - Arcturus
20 - Arcturus

@sriniprad08 
Append tool is what we need.

0106-sriniprad08.PNG

pedrodrfaria
13 - Pulsar

Hi @sriniprad08 

 

See the workflow below.

 

pedrodrfaria_0-1609937615104.png

 

AngelosPachis
16 - Nebula

Hi @sriniprad08 ,

 

To get all the permutation combinations, you can use an append fields tool. Note that in the configuration window of the tool, you should allow all appends, else the tool might error.

 

AngelosPachis_1-1609937617143.png

 

Then it's just a matter of using a formula tool to concatenate the two string fields

 

AngelosPachis_2-1609937646175.png

 

Regards,

 

Angelos

 

 

sriniprad08
11 - Bolide

Thank you @pedrodrfaria @AngelosPachis @Qiu @Kenda . Really appreciate it.

 

I got stuck at one place now i have unequal number of entries but i still the permutation and combination.

 

Please find below,

sriniprad08_0-1609938092749.pngsriniprad08_1-1609938111391.png

 

 

pedrodrfaria
13 - Pulsar

@sriniprad08  We just need to add a filter prior to the append fields. In the filter we will eliminate the null value and do the concatenation. 

 

pedrodrfaria_0-1609938231027.png

 

Qiu
20 - Arcturus
20 - Arcturus

@sriniprad08 
In my case,  one additional filter is required.

0106-sriniprad08-1.PNG

sriniprad08
11 - Bolide

Thank you @Qiu . Great

sriniprad08
11 - Bolide

Thank you @pedrodrfaria  great.

Labels