We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Group rows and create output column with unique key reference

PB41091
8 - Asteroid

Hi have a data which look like this.

Column1Column2
AB1X1
AB1X2
AB1X3
AB1X4
AB1X5
AB1X6
CD1S1
CD1S2
CD1S3
CD1S4
CD1S5
CD1S6
CD1S7
CD1S8
CD1S9
EF1P1
EF1P2
EF1P3
EF1P4
EF1P1
EF1P2
EF1P3
EF1P4
GH5j1
GH5j2
GH5j3
GH5j4

 

And I want to create output column using Column1 and Column2 like below

Output ColumnColumn1Column2
Updated Asumption 1AB1X1
Updated Asumption 1AB1X2
Updated Asumption 1AB1X3
Updated Asumption 1AB1X4
Updated Asumption 1AB1X5
Updated Asumption 1AB1X6
Updated Asumption 2CD1S1
Updated Asumption 2CD1S2
Updated Asumption 2CD1S3
Updated Asumption 2CD1S4
Updated Asumption 2CD1S5
Updated Asumption 2CD1S6
Updated Asumption 2CD1S7
Updated Asumption 2CD1S8
Updated Asumption 2CD1S9
Updated Asumption 3EF1P1
Updated Asumption 3EF1P2
Updated Asumption 3EF1P3
Updated Asumption 3EF1P4
Updated Asumption 4EF1P1
Updated Asumption 4EF1P2
Updated Asumption 4EF1P3
Updated Asumption 4EF1P4
Updated Asumption 5GH5j1
Updated Asumption 5GH5j2
Updated Asumption 5GH5j3
Updated Asumption 5GH5j4
1 REPLY 1
griffinwelsh
12 - Quasar

See the attached solution. This gets the right output and hopefully is a proper understanding of the rules you are looking for.

Labels
Top Solution Authors