Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Compare Table Load to Stored QVD File

Hello,

I have two sources that store  data in the exact same format: 

  • table ITAM54 --> This is today's data
  • savedITAM54 --> yesterdays's data

I need to create a new table that compares the two tables on one column (ID) and ONLY output the differences. 

The results I am looking for: 

ITAM54 (today)   savedITAM54 (yesterday)    Expected Output 
52CAT4/30/2019 34DOG4/29/2019 52CAT4/30/2019
34DOG4/29/2019 65CAT4/18/2019    
65CAT4/18/2019        

 

How can I produce this in the Data Load Editor