Summarize tool
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Dear all,
How can I use more than one input in summarize tool? I want to input data from different sheets which have the same type of data into one summarize tool to have one output.
Thanks
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @MarqueeCrew ,
I tried to achieve this but I couldn't if you can help me in this topic will be much appreciated.
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Using-summarize-function/m-p/575674
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Can you post the data?
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I already posted the sample data file in this post
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Using-summarize-function/m-p/575674
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Your challenge was really about the use of the UNION tool. The three sheets contain similar data, but different schemas.
Sheet 1 contains "order number" and sheet 2 contains "order nymber" and sheet 3 contains "order number". This is just one of the differences.
You need to use the "Manually configure fields" option to align the columns.
Cheers,
Mark
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.