Concatenation

Question

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 Answer

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 Answer

@sriniprad08 
Append tool is what we need.

pedrodrfaria · Accepted Answer

Hi @sriniprad08

See the workflow below.

AngelosPachis · Accepted Answer

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

pedrodrfaria · Accepted Answer

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

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