concatenate columns creating unique values

gshortr

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

Luke_C

Hi @gshortr 

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

New Workflow2.yxmd