Alteryx Designer Desktop Discussions

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

concatenate columns creating unique values

gshortr
6 - Meteoroid

Hi all, a question I suppose is a basic one, I would like to combine / concatenate three columns creating unique values. Column 1 has 3 values, Column 2 has 4, and Column 3 has 5. Using this example I should end up with 60 unique values, as my attached example shows (I only put in the first 10 of the 60 expected outputs...).

 

What tools and or configuration can I use to accomplish this? 

 

Many thanks for any help 🙂

 

Greg

 

gshortr_0-1635798478743.png

 

2 REPLIES 2
Luke_C
17 - Castor

Hi @gshortr 

 

You could use the append fields tool to achieve this, plus a formula tool to concatenate. See attached example. 

 

Luke_C_0-1635798936702.png

 

 

gshortr
6 - Meteoroid

Thanks Luke! Awesome stuff. Much appreciated 🙂

Labels