Alteryx table creation

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.

Workflow

Accepted answers

All comments

alexnajm

I would use a Join tool and select the field(s) that need to be compared between the two. Any "matching" records will come out of the J anchor, and any unmatching records will come out of the respective L and R anchors!

DanielG

@Kumar_vs - building on @alexnajm 's comment. Does this work for what you need?

WeekCounts.yxmd

DanielG

It is a very simple example workflow, but I think the concept would work. 😀

Kumar_vs

thank you for the replies, i want to present the above like a table

DanielG

@Kumar_vs -- do you mean building the report in Alteryx? See this updated workflow for a basic table (with header) example.

WeekCounts w Report.yxmd

DanielG

The Reporting Tool allow for much greater customization of the reports. This is just a basic example again.

Kumar_vs

Much appreciated , thank DanielG for guiding me on this

Kumar_vs

I have started learning Alteryx, so getting so many doubts, i have executed the workflow but it is showing only text ....i am stuck at that report field ...

few more basic questions, would really appreciate if you can help... the below is what in my mind and trying to replicate that on Alteryx

Category	A	B	C	D	E
Last week

Current week

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

AdamR 335