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.
SOLVED

Combine fields and return in a singel cell of a table with line brake after each field

Zukunft
5 - Atom

Hi, 
I'm challenged with a task to read a table and combine all cells returning in a table in a single cell with line break after each  reading cell.

 

Like this example 

Input     
Concern #StatusTeamAction 1Action 2other
1TWO | Y | Y | WARA-TEAM | Name-1 | Name-2 | Nane-3 | Group - 1Test Version 1 | Step1=Step2 | Test1 |  |  | Any other 1 |  |  |  |  |  | 

 

Output 
Concern #Concern Summary
1TWO | Y | Y | WAR 
A-TEAM | Name-1 | Name-2 | Nane-3 | Group - 1 
Test Version 1 | Step1=Step2 | Test1 | 
  |  |  
Any other 1 |  |  |  |  |  | 

 

Thanks for help.

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@Zukunft 
We can use the Transpose tool to bring the data field into a vertical format then a Summarize tool will do the rest.

0924-Zukunft.PNG

Zukunft
5 - Atom

Hi Qiu
works as needed Thank you. :-) 

 

Qiu
21 - Polaris
21 - Polaris

@Zukunft 
Thank you for the feedback and glad to be helpful.

Labels
Top Solution Authors