Concatenation

[sriniprad08]

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.

[Kenda · Accepted solution]

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 · Accepted solution]

@sriniprad08 
Append tool is what we need.

[pedrodrfaria · Accepted solution]

Hi @sriniprad08 

See the workflow below.

[AngelosPachis · Accepted solution]

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.

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

Regards,

Angelos

[sriniprad08]

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,

[pedrodrfaria · Accepted solution]

@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. 

[Qiu · Accepted solution]

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

[sriniprad08]

Thank you @Qiu . Great

[sriniprad08]

Thank you @pedrodrfaria  great.