topic Re: How to merge new data with old data in App Development

topic Re: How to merge new data with old data in App Development https://community.qlik.com/t5/App-Development/How-to-merge-new-data-with-old-data/m-p/2027236#M84669 <P>Thanks <a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/6142">@Or</a> </P> Wed, 18 Jan 2023 14:45:55 GMT Sra1bandi 2023-01-18T14:45:55Z How to merge new data with old data https://community.qlik.com/t5/App-Development/How-to-merge-new-data-with-old-data/m-p/2027183#M84662 <P>Hi Team,</P> <P> </P> <P>Need to display new data instead of world data</P> <P>Old data:-</P> <TABLE width="710px"> <TBODY> <TR> <TD width="281.052px" height="46px"> Description</TD> <TD width="52.9583px" height="46px">Class</TD> <TD width="75.9062px" height="46px">key</TD> <TD width="67.5833px" height="46px">Opening Date</TD> <TD width="40px">Closing Date</TD> <TD width="40px">Duration(Days)</TD> <TD width="62.9375px" height="46px">Status</TD> <TD width="88.8958px" height="46px">Range Request</TD> </TR> <TR> <TD width="281.052px" height="24px">MIRAVIS 4X5 L                        JPA</TD> <TD width="52.9583px" height="24px">SU</TD> <TD width="75.9062px" height="24px">284532</TD> <TD width="67.5833px" height="24px">28-04-2020</TD> <TD width="40px"> </TD> <TD width="40px"> </TD> <TD width="62.9375px" height="24px">Error</TD> <TD width="88.8958px" height="24px">1</TD> </TR> <TR> <TD width="281.052px" height="24px">AMPLIGO 150 ZC 110X40 ML             UAP</TD> <TD width="52.9583px" height="24px">SU</TD> <TD width="75.9062px" height="24px">292244</TD> <TD width="67.5833px" height="24px">08-10-2020</TD> <TD width="40px"> </TD> <TD width="40px"> </TD> <TD width="62.9375px" height="24px">Error</TD> <TD width="88.8958px" height="24px">7360</TD> </TR> <TR> <TD width="281.052px" height="24px">CRUISER SB EXPORT CLP 200 L          DKA</TD> <TD width="52.9583px" height="24px">SU</TD> <TD width="75.9062px" height="24px">293504</TD> <TD width="67.5833px" height="24px">02-11-2020</TD> <TD width="40px"> </TD> <TD width="40px"> </TD> <TD width="62.9375px" height="24px">Error</TD> <TD width="88.8958px" height="24px">1</TD> </TR> <TR> <TD width="281.052px" height="24px">VENCENDO 20X1 KG                     INA</TD> <TD width="52.9583px" height="24px">SU</TD> <TD width="75.9062px" height="24px">315322</TD> <TD width="67.5833px" height="24px">25-01-2022</TD> <TD width="40px"> </TD> <TD width="40px"> </TD> <TD width="62.9375px" height="24px">Error</TD> <TD width="88.8958px" height="24px">13791</TD> </TR> <TR> <TD width="281.052px" height="24px">VENCENDO 4X5 KG                      INA</TD> <TD width="52.9583px" height="24px">SU</TD> <TD width="75.9062px" height="24px">315324</TD> <TD width="67.5833px" height="24px">25-01-2022</TD> <TD width="40px"> </TD> <TD width="40px"> </TD> <TD width="62.9375px" height="24px">Error</TD> <TD width="88.8958px" height="24px">13791</TD> </TR> <TR> <TD width="281.052px" height="24px">TAMYGIA 20X1 KG                      INA</TD> <TD width="52.9583px" height="24px">SU</TD> <TD width="75.9062px" height="24px">315325</TD> <TD width="67.5833px" height="24px">25-01-2022</TD> <TD width="40px"> </TD> <TD width="40px"> </TD> <TD width="62.9375px" height="24px">Error</TD> <TD width="88.8958px" height="24px">13791</TD> </TR> <TR> <TD width="281.052px" height="24px">TAMYGIA 8X2.5 KG                     INA</TD> <TD width="52.9583px" height="24px">SU</TD> <TD width="75.9062px" height="24px">315326</TD> <TD width="67.5833px" height="24px">25-01-2022</TD> <TD width="40px"> </TD> <TD width="40px"> </TD> <TD width="62.9375px" height="24px">Error</TD> <TD width="88.8958px" height="24px">13791</TD> </TR> <TR> <TD width="281.052px" height="24px">TAMYGIA 4X5 KG                       INA</TD> <TD width="52.9583px" height="24px">SU</TD> <TD width="75.9062px" height="24px">315327</TD> <TD width="67.5833px" height="24px">25-01-2022</TD> <TD width="40px"> </TD> <TD width="40px"> </TD> <TD width="62.9375px" height="24px">Error</TD> <TD width="88.8958px" height="24px">13791</TD> </TR> </TBODY> </TABLE> <P> </P> <P> </P> <P>New data:-</P> <TABLE width="1015"> <TBODY> <TR> <TD width="289.188px" height="46px"> Description</TD> <TD width="60.5208px" height="46px">Class</TD> <TD width="83.5417px" height="46px">key</TD> <TD width="119.396px" height="46px">Opening Date</TD> <TD width="111.417px" height="46px"> Closing Date</TD> <TD width="110.729px" height="46px">Duration(Days)</TD> <TD width="143.448px" height="46px">Status</TD> <TD width="96.0938px" height="46px">Range Request</TD> </TR> <TR> <TD width="289.188px" height="24px">MIRAVIS 4X5 L                        JPA</TD> <TD width="60.5208px" height="24px">SU</TD> <TD width="83.5417px" height="24px">284532</TD> <TD width="119.396px" height="24px">28-04-2020</TD> <TD width="111.417px" height="24px">28-04-2020</TD> <TD width="110.729px" height="24px">0</TD> <TD width="143.448px" height="24px">CANCELLED</TD> <TD width="96.0938px" height="24px">1</TD> </TR> <TR> <TD width="289.188px" height="24px">AMPLIGO 150 ZC 110X40 ML             UAP</TD> <TD width="60.5208px" height="24px">SU</TD> <TD width="83.5417px" height="24px">292244</TD> <TD width="119.396px" height="24px">08-10-2020</TD> <TD width="111.417px" height="24px">08-10-2020</TD> <TD width="110.729px" height="24px">0</TD> <TD width="143.448px" height="24px">CANCELLED</TD> <TD width="96.0938px" height="24px">7360</TD> </TR> <TR> <TD width="289.188px" height="24px">CRUISER SB EXPORT CLP 200 L          DKA</TD> <TD width="60.5208px" height="24px">SU</TD> <TD width="83.5417px" height="24px">293504</TD> <TD width="119.396px" height="24px">02-11-2020</TD> <TD width="111.417px" height="24px">12-11-2020</TD> <TD width="110.729px" height="24px">8</TD> <TD width="143.448px" height="24px">COMPLETED</TD> <TD width="96.0938px" height="24px">1</TD> </TR> <TR> <TD width="289.188px" height="24px">VENCENDO 20X1 KG                     INA</TD> <TD width="60.5208px" height="24px">SU</TD> <TD width="83.5417px" height="24px">315322</TD> <TD width="119.396px" height="24px">25-01-2022</TD> <TD width="111.417px" height="24px">18-05-2022</TD> <TD width="110.729px" height="24px">81</TD> <TD width="143.448px" height="24px">COMPLETED</TD> <TD width="96.0938px" height="24px">13791</TD> </TR> <TR> <TD width="289.188px" height="24px">VENCENDO 4X5 KG                      INA</TD> <TD width="60.5208px" height="24px">SU</TD> <TD width="83.5417px" height="24px">315324</TD> <TD width="119.396px" height="24px">25-01-2022</TD> <TD width="111.417px" height="24px">18-05-2022</TD> <TD width="110.729px" height="24px">81</TD> <TD width="143.448px" height="24px">COMPLETED</TD> <TD width="96.0938px" height="24px">13791</TD> </TR> <TR> <TD width="289.188px" height="24px">TAMYGIA 20X1 KG                      INA</TD> <TD width="60.5208px" height="24px">SU</TD> <TD width="83.5417px" height="24px">315325</TD> <TD width="119.396px" height="24px">25-01-2022</TD> <TD width="111.417px" height="24px">18-05-2022</TD> <TD width="110.729px" height="24px">81</TD> <TD width="143.448px" height="24px">COMPLETED</TD> <TD width="96.0938px" height="24px">13791</TD> </TR> <TR> <TD width="289.188px" height="24px">TAMYGIA 8X2.5 KG                     INA</TD> <TD width="60.5208px" height="24px">SU</TD> <TD width="83.5417px" height="24px">315326</TD> <TD width="119.396px" height="24px">25-01-2022</TD> <TD width="111.417px" height="24px">18-05-2022</TD> <TD width="110.729px" height="24px">81</TD> <TD width="143.448px" height="24px">COMPLETED</TD> <TD width="96.0938px" height="24px">13791</TD> </TR> <TR> <TD width="289.188px" height="24px">TAMYGIA 4X5 KG                       INA</TD> <TD width="60.5208px" height="24px">SU</TD> <TD width="83.5417px" height="24px">315327</TD> <TD width="119.396px" height="24px">25-01-2022</TD> <TD width="111.417px" height="24px">18-05-2022</TD> <TD width="110.729px" height="24px">81</TD> <TD width="143.448px" height="24px">COMPLETED</TD> <TD width="96.0938px" height="24px">13791</TD> </TR> </TBODY> </TABLE> <P> </P> <P> </P> <P>I need result like below table </P> <P>When i am trying to do Concatenate/Join both are showing old and new data i need to replace old data with new data.</P> <P> </P> <P>Regards,</P> <P>Sravan.</P> Wed, 18 Jan 2023 13:10:10 GMT https://community.qlik.com/t5/App-Development/How-to-merge-new-data-with-old-data/m-p/2027183#M84662 Sra1bandi 2023-01-18T13:10:10Z Re: How to merge new data with old data https://community.qlik.com/t5/App-Development/How-to-merge-new-data-with-old-data/m-p/2027209#M84664 <P>Perhaps:</P> <P>Load * From NewData;</P> <P>Concatenate</P> <P>Load * From OldData</P> <P>Where Not Exists(Key);</P> Wed, 18 Jan 2023 14:02:35 GMT https://community.qlik.com/t5/App-Development/How-to-merge-new-data-with-old-data/m-p/2027209#M84664 Or 2023-01-18T14:02:35Z Re: How to merge new data with old data https://community.qlik.com/t5/App-Development/How-to-merge-new-data-with-old-data/m-p/2027236#M84669 <P>Thanks <a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/6142">@Or</a> </P> Wed, 18 Jan 2023 14:45:55 GMT https://community.qlik.com/t5/App-Development/How-to-merge-new-data-with-old-data/m-p/2027236#M84669 Sra1bandi 2023-01-18T14:45:55Z