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