Alteryx Designer Desktop Discussions

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

Table creation - alteryx

Kumar_vs
6 - Meteoroid

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. 

 

1 REPLY 1
FrederikE
13 - Pulsar

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. 

Labels
Top Solution Authors