Table creation - alteryx

[Kumar_vs]

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. 

[FrederikE · Accepted solution]

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.