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.

Merging Data in multiple rows

rohitashsharma
8 - Asteroid

Hi,

 

I have an invoice data where some activities happened on each day and every day a new row is created where each row has been given a sequence number and also put some comment at each sequence number and I want to merge the sequence and comments the way in given in the below screen shot, would request if someone can help me with the same:

 

rohitashsharma_0-1684859654117.png

 

Thanks,

Rohitash

 

2 REPLIES 2
FrederikE
13 - Pulsar

Hey @rohitashsharma

 

This should achive it.

 

FrederikE_0-1684860246384.png

 

rohitashsharma
8 - Asteroid

Thanks FrederikE for the quick response I appreciate it.

 

I am sure it should work, I have huge data set taking too long to pull, will test and confirm about the result soon.

 

Regards,

Rohitash

Labels
Top Solution Authors