Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Record stacking

alexlyle
8 - Asteroid
‎06-04-2020 07:48 AM

Good morning, Alteryx community. I imagine the solution to this issue lays with the cross tab but I cannot figure it out.I want to take data like the 2 row in Part I of the attached file and combine and concatenate them into 1 row like in  Part II. Note how there are multiple fields being concatenated. Thanks for any help

Preview file
10 KB
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
fmvizcaino
17 - Castor
17 - Castor
‎06-04-2020 08:28 AM

Hi @alexlyle ,

 

You can accomplish that by using the concatenate option from the summarize tool.

fmvizcaino_0-1591284510432.png

 

 

Best,

Fernando Vizcaino

2020-06-04 Record stacking.yxmd
Reply
0 Likes
rupali_bhise
8 - Asteroid
‎06-04-2020 08:34 AM

Hey @alexlyle , 

 

You can use Transpose + Crosstab and get desired output you want. Attaching workflow for reference.

Good luck.

 

Record stacking.png

Record stacking.yxmd
Reply
0 Likes
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All