topic Compare Table Load to Stored QVD File in App Development

topic Compare Table Load to Stored QVD File in App Development https://community.qlik.com/t5/App-Development/Compare-Table-Load-to-Stored-QVD-File/m-p/1575182#M41906 <P>Hello,</P><P>I have two sources that store  data in the exact same format: </P><UL><LI>table ITAM54 --> This is today's data</LI><LI>savedITAM54 --> yesterdays's data</LI></UL><P>I need to create a new table that compares the two tables on one column (ID) and ONLY output the differences. </P><P>The results I am looking for: </P><TABLE><TBODY><TR><TD>ITAM54 (today)</TD><TD> </TD><TD> </TD><TD> </TD><TD>savedITAM54 (yesterday)</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>Expected Output</TD><TD> </TD></TR><TR><TD>52</TD><TD>CAT</TD><TD>4/30/2019</TD><TD> </TD><TD>34</TD><TD>DOG</TD><TD>4/29/2019</TD><TD> </TD><TD>52</TD><TD>CAT</TD><TD>4/30/2019</TD></TR><TR><TD>34</TD><TD>DOG</TD><TD>4/29/2019</TD><TD> </TD><TD>65</TD><TD>CAT</TD><TD>4/18/2019</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>65</TD><TD>CAT</TD><TD>4/18/2019</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR></TBODY></TABLE><P> </P><P>How can I produce this in the Data Load Editor</P> Tue, 30 Apr 2019 15:22:52 GMT esuper21 2019-04-30T15:22:52Z Compare Table Load to Stored QVD File https://community.qlik.com/t5/App-Development/Compare-Table-Load-to-Stored-QVD-File/m-p/1575182#M41906 <P>Hello,</P><P>I have two sources that store  data in the exact same format: </P><UL><LI>table ITAM54 --> This is today's data</LI><LI>savedITAM54 --> yesterdays's data</LI></UL><P>I need to create a new table that compares the two tables on one column (ID) and ONLY output the differences. </P><P>The results I am looking for: </P><TABLE><TBODY><TR><TD>ITAM54 (today)</TD><TD> </TD><TD> </TD><TD> </TD><TD>savedITAM54 (yesterday)</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>Expected Output</TD><TD> </TD></TR><TR><TD>52</TD><TD>CAT</TD><TD>4/30/2019</TD><TD> </TD><TD>34</TD><TD>DOG</TD><TD>4/29/2019</TD><TD> </TD><TD>52</TD><TD>CAT</TD><TD>4/30/2019</TD></TR><TR><TD>34</TD><TD>DOG</TD><TD>4/29/2019</TD><TD> </TD><TD>65</TD><TD>CAT</TD><TD>4/18/2019</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>65</TD><TD>CAT</TD><TD>4/18/2019</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR></TBODY></TABLE><P> </P><P>How can I produce this in the Data Load Editor</P> Tue, 30 Apr 2019 15:22:52 GMT https://community.qlik.com/t5/App-Development/Compare-Table-Load-to-Stored-QVD-File/m-p/1575182#M41906 esuper21 2019-04-30T15:22:52Z