topic Compare 2 different tables having same columns and difference in data in App Development https://community.qlik.com/t5/App-Development/Compare-2-different-tables-having-same-columns-and-difference-in/m-p/2086201#M89059 <P>Hi team,</P> <P>We have 2 different sources as below having same column names but difference in data.</P> <P>T1:</P> <TABLE width="277"> <TBODY> <TR> <TD width="33">ID</TD> <TD width="88">Reference</TD> <TD width="51">Price</TD> <TD width="105">Date</TD> </TR> <TR> <TD>A1</TD> <TD>1234</TD> <TD>100</TD> <TD>Jun-23</TD> </TR> <TR> <TD>A2</TD> <TD>2345</TD> <TD>200</TD> <TD>Jun-23</TD> </TR> <TR> <TD>A3</TD> <TD>3456</TD> <TD>300</TD> <TD>Jun-23</TD> </TR> <TR> <TD>A4</TD> <TD>4567</TD> <TD>100</TD> <TD>Jun-23</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>&nbsp;</P> <P>T2:</P> <TABLE width="241"> <TBODY> <TR> <TD width="98">Reference</TD> <TD width="64">Price</TD> <TD width="79">Date</TD> </TR> <TR> <TD>1234</TD> <TD>100</TD> <TD>Jun-23</TD> </TR> <TR> <TD>2345</TD> <TD>300</TD> <TD>Jun-23</TD> </TR> <TR> <TD>3456</TD> <TD>200</TD> <TD>Jun-23</TD> </TR> <TR> <TD>5678</TD> <TD>400</TD> <TD>Jun-23</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Need to create flags few below scenarios.</P> <TABLE width="553"> <TBODY> <TR> <TD width="28">#</TD> <TD width="525">Need</TD> </TR> <TR> <TD>1</TD> <TD>Show only excess records of T1&nbsp;</TD> </TR> <TR> <TD>2</TD> <TD>Show only excess records of T2</TD> </TR> <TR> <TD>3</TD> <TD>If Reference is there in both and Price is different Flag those records</TD> </TR> <TR> <TD>4</TD> <TD>If Reference is there in T1 and missing in T2 or vise versa, Flag them with Table name</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Could you please help me with your ideas.</P> <P>Thank you!</P> Fri, 15 Nov 2024 21:39:34 GMT bhargavikn 2024-11-15T21:39:34Z Compare 2 different tables having same columns and difference in data https://community.qlik.com/t5/App-Development/Compare-2-different-tables-having-same-columns-and-difference-in/m-p/2086201#M89059 <P>Hi team,</P> <P>We have 2 different sources as below having same column names but difference in data.</P> <P>T1:</P> <TABLE width="277"> <TBODY> <TR> <TD width="33">ID</TD> <TD width="88">Reference</TD> <TD width="51">Price</TD> <TD width="105">Date</TD> </TR> <TR> <TD>A1</TD> <TD>1234</TD> <TD>100</TD> <TD>Jun-23</TD> </TR> <TR> <TD>A2</TD> <TD>2345</TD> <TD>200</TD> <TD>Jun-23</TD> </TR> <TR> <TD>A3</TD> <TD>3456</TD> <TD>300</TD> <TD>Jun-23</TD> </TR> <TR> <TD>A4</TD> <TD>4567</TD> <TD>100</TD> <TD>Jun-23</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>&nbsp;</P> <P>T2:</P> <TABLE width="241"> <TBODY> <TR> <TD width="98">Reference</TD> <TD width="64">Price</TD> <TD width="79">Date</TD> </TR> <TR> <TD>1234</TD> <TD>100</TD> <TD>Jun-23</TD> </TR> <TR> <TD>2345</TD> <TD>300</TD> <TD>Jun-23</TD> </TR> <TR> <TD>3456</TD> <TD>200</TD> <TD>Jun-23</TD> </TR> <TR> <TD>5678</TD> <TD>400</TD> <TD>Jun-23</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Need to create flags few below scenarios.</P> <TABLE width="553"> <TBODY> <TR> <TD width="28">#</TD> <TD width="525">Need</TD> </TR> <TR> <TD>1</TD> <TD>Show only excess records of T1&nbsp;</TD> </TR> <TR> <TD>2</TD> <TD>Show only excess records of T2</TD> </TR> <TR> <TD>3</TD> <TD>If Reference is there in both and Price is different Flag those records</TD> </TR> <TR> <TD>4</TD> <TD>If Reference is there in T1 and missing in T2 or vise versa, Flag them with Table name</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Could you please help me with your ideas.</P> <P>Thank you!</P> Fri, 15 Nov 2024 21:39:34 GMT https://community.qlik.com/t5/App-Development/Compare-2-different-tables-having-same-columns-and-difference-in/m-p/2086201#M89059 bhargavikn 2024-11-15T21:39:34Z