Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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