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
Solved! Go to 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
Hello,
Apologize for the delay and it worked thanks.