community Alteryx IO Alteryx.com
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
Free Trial

Alteryx Designer Desktop Discussions

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

Grouping of data

Sid_102582
5 - Atom
‎01-04-2023 09:13 AM

I have below input

Sid_102582_0-1672852169703.png

and i have to group it or club it into below format.

Sid_102582_1-1672852219952.png

All blank spaces are null, 

Please let me know any potential solution,

Thanks in advance

Labels:
Reply
2 REPLIES 2
Felipe_Ribeir0
16 - Nebula
‎01-04-2023 09:16 AM

Hi @Sid_102582 

 

You can use the summarize tool to do it

 

Felipe_Ribeir0_0-1672852578895.png

 

Grouping of data.yxmd
Reply
0 Likes
ShankerV
17 - Castor
‎01-04-2023 09:18 AM

Hi @Sid_102582 

 

Please find the expected output.

 

ShankerV_0-1672852674172.png

 

Grouping of data.yxmd
Reply
0 Likes
Labels