What has Changed ?

Question

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.

Expexted Output.png

grossal · Accepted Answer

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 Answer

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 · Accepted Answer

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.