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.

Issue with formatting of final, Group by

awanishyadavv
7 - Meteor

Hello

I need final data that contains multiple rows and columns of information for the same user. Each column contains different values, but some columns, such as name, phone, and email, may have duplicate values across multiple rows.

 

Attached Excel File contain, input and desired output sample.
Example: This is my final outcome from the workflow.

 

 

Screenshot 2024-07-26 120213.png

 

How I want it in my result (please ref: following Image---------------------------------(checkout atached excel file) ?
Screenshot 2024-07-26 115458.png


This is my snippet workflow:
Screenshot 2024-07-26 113427.png

 

 

2 REPLIES 2
Qiu
21 - Polaris
21 - Polaris

@awanishyadavv 
How about using the Concatenate feature in the Summarize Tool?

0726-awanishyadavv.png

awanishyadavv
7 - Meteor

@Qiu It will append all the fields into one cell for any column, which is not the requirement.
Final output has to be as stated in the image.

 

Labels
Top Solution Authors