community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Appending to the new row

Atom

Hi Everyone,

 

I'm a newbee to Alteryx and I have a small requirement to build the workflow:

 

Comparing the current row to the previous row. if the current row of the first three columns are same to the previous row then the last two columns data should be appended, otherwise data should remain same  Eg:

ABCDE
12345
12367
52489

Here, in the above table first two rows are same for first three columns therefore the data should be appended for the column D and E and third row data should remain as it is:

Output:

 

ABCDED1E1
1234567
52489  
Pulsar

There's likely a better way to do this using only Multi-Row Formulas, but I jump at the chance to use Transpose/Cross Tab:

image.png

This can handle however many duplicates you throw at it and will split them into individual columns.

Highlighted
Atom

Thanks it worked :)

 

 

Labels