What has Changed ?

[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.

[grossal · Accepted solution]

Hi @suby,

here is quick way to do this:

Output:

What happens:

1) I join the months based on the ID column

2) Formula to identify changes

IF [Stage] = [Right_Stage]
THEN "No changes"
ELSE "Moved from " + [Stage] + " to " + [Right_Stage]
ENDIF

3) Removing Stage Columns

Workflow attached. Let me know what you think 😃

Best

Alex

[Jonathan-Sherman · Accepted solution]

Hi @suby,

I think this solves your issue, join together and create an IF formula:

IF [STAGE] = [Right_STAGE]
THEN 'No changes'
ELSE 'Moved from ' + [STAGE] + ' to ' + [Right_STAGE]
ENDIF

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[suby]

Hello,

Thanks for your solution it works great. Thanks

[suby]

Hello Jonathan,

Thanks so much for your solution and it works great thanks.

Thanks

[suby · Accepted solution]

Hello Jonathan,

Thanks for sharing the solution and since I accepted Grossal one as a solution and I couldn't accept yours  as a solution so please apologize me for that.

Community Admin,

I would like to accept Jonathan's one as solution as well  please let me know how we can accept both as solutions in the community.

[suby]

Hello Jonathan

Thanks for the solution and it works and in my real world I have multiple criteria not just STG 1 to STG3 in order for me to  track the Data changes over the period of time against multiple criteria is there a way to write any scripts or set of rules and execute that in automated fashion as in when we add monthly Data.