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