Table creation - alteryx
- 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
I am trying to compare two excels, one has last week data and another one has current data.
1) I am trying to identify common items in last two weeks - need count break up by type of item
2) items which are not there last week but added this week - need count break up by type of item
3) Items which are there last week but not there this week - need count break up by type of item
I am looking for the count for the above, how to get this data? any kind of help would be great help. i am trying to create a table for the above where i want to see the data with alteryx workflow.
Solved! Go to Solution.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @Kumar_vs,
You could join both datasets on the item type:
- Your Inner Output will be common items,
- Left and Right will be the missing items from the other week.
Then you can use a Summarize Tool with Group by Item type and Count Item type on all 3 different Join outputs.
![](/skins/images/12DF86F0CA96E81F3ABF675C1590B6DD/responsive_peak/images/icon_anonymous_message.png)