What has Changed in Data?

[suby]

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

[RolandSchubert · Accepted solution]

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]

Hello,

Apologize for the delay and it worked thanks.