In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Compress or summarize data

kayogunbo
7 - Meteor

Dear experts,

 

I need your help with aggregating information. I can do a similar one with a pivot but i am struggling to achieve same with Alteryx.

 

So, i have data coming from 3 sources and i had used a union tool to join them together.. However, i want to be able to compress the data before sending it to my DB. I have attached a dummy sample and the desired output using excel.

 

Many thanks!

Kay O.

1 REPLY 1
Jonathan-Sherman
15 - Aurora
15 - Aurora

Hi @kayogunbo,

 

You could achieve this with a summarise tool:

 

JonathanSherman_0-1636461813597.png

 

I've attached my workflow for you to download if needed!

 

Kind regards,

Jonathan

 

Labels
Top Solution Authors