topic Merging Data in QlikView https://community.qlik.com/t5/QlikView/Merging-Data/m-p/1845372#M1215443 <P>Hi All,</P><P>I have an issue that should be solved urgently. The problem that I faced is merging to data sets. to describe better;&nbsp;</P><UL><LI>Data set 1 : This data set demonstrates first test results each ID&nbsp;</LI></UL><TABLE><TBODY><TR><TD><P>Test ID</P></TD><TD><P>Active 1&nbsp;</P></TD><TD><P>Active 2&nbsp;</P></TD><TD><P>Active 3</P></TD><TD><P>Active 4&nbsp;</P></TD></TR><TR><TD><P>1234</P></TD><TD><P>2.1</P></TD><TD><P>3.2</P></TD><TD><P>0</P></TD><TD><P>0.4</P></TD></TR><TR><TD><P>5678</P></TD><TD><P>3.3</P></TD><TD><P>1.2</P></TD><TD><P>5.7</P></TD><TD><P>0.2</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><UL><LI>Data set 2 : This data set&nbsp;demonstrates second test results of Active 2 for Test ID 1234 and&nbsp;second test results of Active 3 for Test ID 5678 .</LI></UL><TABLE><TBODY><TR><TD><P>Test ID</P></TD><TD><P>Active 1&nbsp;</P></TD><TD><P>Active 2&nbsp;</P></TD><TD><P>Active 3</P></TD><TD><P>Active 4&nbsp;</P></TD></TR><TR><TD><P>1234</P></TD><TD><P>Not tested</P></TD><TD><P>0.3</P></TD><TD><P>Not tested</P></TD><TD><P>Not tested</P></TD></TR><TR><TD><P>5678</P></TD><TD><P>Not tested</P></TD><TD><P>Not tested</P></TD><TD><P>2.3</P></TD><TD><P>Not tested</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><UL><LI>Merging data sets : I need a function to be able to update only if any active has a new result but if there is no second test performed to keep first test result.</LI></UL><TABLE><TBODY><TR><TD><P>Test ID</P></TD><TD><P>Active 1&nbsp;</P></TD><TD><P>Active 2&nbsp;</P></TD><TD><P>Active 3</P></TD><TD><P>Active 4&nbsp;</P></TD></TR><TR><TD><P>1234</P></TD><TD><P>2.1</P></TD><TD><P>0.3</P></TD><TD><P>0</P></TD><TD><P>0.4</P></TD></TR><TR><TD><P>5678</P></TD><TD><P>3.3</P></TD><TD><P>1.2</P></TD><TD><P>2.3</P></TD><TD><P>0.2</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thank you in advance, I'll be appreciated if anyone can support me to find a solution.&nbsp;</P><P>Regards</P><P>Mehmet</P> Tue, 12 Oct 2021 09:02:04 GMT mhamurcuoglu 2021-10-12T09:02:04Z Merging Data https://community.qlik.com/t5/QlikView/Merging-Data/m-p/1845372#M1215443 <P>Hi All,</P><P>I have an issue that should be solved urgently. The problem that I faced is merging to data sets. to describe better;&nbsp;</P><UL><LI>Data set 1 : This data set demonstrates first test results each ID&nbsp;</LI></UL><TABLE><TBODY><TR><TD><P>Test ID</P></TD><TD><P>Active 1&nbsp;</P></TD><TD><P>Active 2&nbsp;</P></TD><TD><P>Active 3</P></TD><TD><P>Active 4&nbsp;</P></TD></TR><TR><TD><P>1234</P></TD><TD><P>2.1</P></TD><TD><P>3.2</P></TD><TD><P>0</P></TD><TD><P>0.4</P></TD></TR><TR><TD><P>5678</P></TD><TD><P>3.3</P></TD><TD><P>1.2</P></TD><TD><P>5.7</P></TD><TD><P>0.2</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><UL><LI>Data set 2 : This data set&nbsp;demonstrates second test results of Active 2 for Test ID 1234 and&nbsp;second test results of Active 3 for Test ID 5678 .</LI></UL><TABLE><TBODY><TR><TD><P>Test ID</P></TD><TD><P>Active 1&nbsp;</P></TD><TD><P>Active 2&nbsp;</P></TD><TD><P>Active 3</P></TD><TD><P>Active 4&nbsp;</P></TD></TR><TR><TD><P>1234</P></TD><TD><P>Not tested</P></TD><TD><P>0.3</P></TD><TD><P>Not tested</P></TD><TD><P>Not tested</P></TD></TR><TR><TD><P>5678</P></TD><TD><P>Not tested</P></TD><TD><P>Not tested</P></TD><TD><P>2.3</P></TD><TD><P>Not tested</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><UL><LI>Merging data sets : I need a function to be able to update only if any active has a new result but if there is no second test performed to keep first test result.</LI></UL><TABLE><TBODY><TR><TD><P>Test ID</P></TD><TD><P>Active 1&nbsp;</P></TD><TD><P>Active 2&nbsp;</P></TD><TD><P>Active 3</P></TD><TD><P>Active 4&nbsp;</P></TD></TR><TR><TD><P>1234</P></TD><TD><P>2.1</P></TD><TD><P>0.3</P></TD><TD><P>0</P></TD><TD><P>0.4</P></TD></TR><TR><TD><P>5678</P></TD><TD><P>3.3</P></TD><TD><P>1.2</P></TD><TD><P>2.3</P></TD><TD><P>0.2</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thank you in advance, I'll be appreciated if anyone can support me to find a solution.&nbsp;</P><P>Regards</P><P>Mehmet</P> Tue, 12 Oct 2021 09:02:04 GMT https://community.qlik.com/t5/QlikView/Merging-Data/m-p/1845372#M1215443 mhamurcuoglu 2021-10-12T09:02:04Z