Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

What has Changed in Data?

suby
11 - Bolide

 

Hello All,

 

I have a requirement to find the changes in the data over the period of time.

 

Say for example I have two table  out put Data in a excel file  for January and February and I want to produce a new out put file which tracks the changes in the data for the month of February when compared to January.

Attached the screenshot of expected result.

 

I 've already got a solution for this but I would like to understand if there is a way where I can write all my rules in one script file and use that on a monthly basis.

 

Thanks

2 REPLIES 2
RolandSchubert
16 - Nebula
16 - Nebula

Hi @suby ,

 

I think, it's basically a Join (data month 1 to data month 2 on ID) and a comparison using a formula tool.  I've attached a sample workflow. 
What do you think?

 

Best,

 

Roland

suby
11 - Bolide

Hello,

 

Apologize for the delay and it worked thanks.

Labels