SOLVED
Compress or summarize data
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
kayogunbo
7 - Meteor
‎11-09-2021
04:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
Labels:
- Labels:
- Transformation
1 REPLY 1
15 - Aurora
‎11-09-2021
04:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @kayogunbo,
You could achieve this with a summarise tool:
I've attached my workflow for you to download if needed!
Kind regards,
Jonathan
