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.
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!
It is a very simple example workflow, but I think the concept would work. 😀
thank you for the replies, i want to present the above like a table
@Kumar_vs -- do you mean building the report in Alteryx? See this updated workflow for a basic table (with header) example.
The Reporting Tool allow for much greater customization of the reports. This is just a basic example again. :)
Much appreciated , thank DanielG for guiding me on this
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 |
User | Count |
---|---|
61 | |
24 | |
23 | |
21 | |
20 |