We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Alteryx table creation

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. 

9 REPLIES 9
alexnajm
18 - Pollux
18 - Pollux

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
12 - Quasar

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

 

 

DanielG
12 - Quasar

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

Kumar_vs
6 - Meteoroid

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

DanielG
12 - Quasar

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

DanielG
12 - Quasar

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

Kumar_vs
6 - Meteoroid

Much appreciated , thank DanielG for guiding me on this 

Kumar_vs
6 - Meteoroid

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 ABCDE
Last week      
      
Current week      

 

nagakavyasri
12 - Quasar
Labels
Top Solution Authors