How to detect changes in two excel files using QlikSense?

[hp13]

Hi I have to generate daily report to compare 

Two files:

Yesterday file:

Srno, WorkerName, Role, StartDate, EndDate

1, XYZ, TESTER, 1/27/2023, 11/28/2023

2, ABC, QA, 11/1/2023, 11/28/2023

Today file

Srno, WorkerName, Role, StartDate, EndDate

1, XYZ, QA, 11/28/2023, NA

2, CDE, DEV, 10/1/2023, 10/28/2023

EXPECTED SCENARIO: 

Role changed:  XYZ--> from TESTER to QA

[TcnCunha_M · Accepted solution]

Hello

You need to have the file store in daily basis to be able to analyze the difference in first place.
One you have this, you load the Data form yesterday + today, sort the data by ID
and check  each field if has change  for example

If( Previous(Srno) = Srno,

If(Previous(Worker)  <>  Worker Or

If(Previous(Name)  <>  Name Or

If(Previous(Role)  <>  Role Or

If(Previous(StartDate)  <>  StartDate Or

If(Previous(EndDate)  <>  EndDate , 1 , 0 ) ))) As [ Check data changed]

Then you can store only the changed rows in one Qvd in incremental load and analyze what was changed

[hp13]

Thank you so much for your quick response and for providing solution. I really appreciate it 🙂

[TcnCunha_M]

Np anytime 😄