Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
esuper21
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

0 Replies