Qlik Community

Qlik Sense App Development

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

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
New 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