Concatenation
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
- Labels:
- Data Investigation
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@sriniprad08
Append tool is what we need.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@sriniprad08
In my case, one additional filter is required.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you @Qiu . Great
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you @pedrodrfaria great.