https://community.qlik.com/t5/QlikView/Mergining-data-sets/m-p/1845337#M1215441 <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 border="1"><TBODY><TR><TD>Test ID</TD><TD>Active 1&nbsp;</TD><TD>Active 2&nbsp;</TD><TD>Active 3</TD><TD>Active 4&nbsp;</TD></TR><TR><TD>1234</TD><TD>2.1</TD><TD>3.2</TD><TD>0</TD><TD>0.4</TD></TR><TR><TD>5678</TD><TD>3.3</TD><TD>1.2</TD><TD>5.7</TD><TD>0.2</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 border="1"><TBODY><TR><TD>Test ID</TD><TD>Active 1&nbsp;</TD><TD>Active 2&nbsp;</TD><TD>Active 3</TD><TD>Active 4&nbsp;</TD></TR><TR><TD>1234</TD><TD>Not tested</TD><TD>0.3</TD><TD>Not tested</TD><TD>Not tested</TD></TR><TR><TD>5678</TD><TD>Not tested</TD><TD>Not tested</TD><TD>2.3</TD><TD>Not tested</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 border="1"><TBODY><TR><TD>Test ID</TD><TD>Active 1&nbsp;</TD><TD>Active 2&nbsp;</TD><TD>Active 3</TD><TD>Active 4&nbsp;</TD></TR><TR><TD>1234</TD><TD>2.1</TD><TD><FONT color="#FF0000">0.3</FONT></TD><TD>0</TD><TD>0.4</TD></TR><TR><TD>5678</TD><TD>3.3</TD><TD>1.2</TD><TD><FONT color="#FF0000">2.3</FONT></TD><TD>0.2</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 08:24:58 GMT mhamurcuoglu 2021-10-12T08:24:58Z https://community.qlik.com/t5/QlikView/Mergining-data-sets/m-p/1845337#M1215441 <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 border="1"><TBODY><TR><TD>Test ID</TD><TD>Active 1&nbsp;</TD><TD>Active 2&nbsp;</TD><TD>Active 3</TD><TD>Active 4&nbsp;</TD></TR><TR><TD>1234</TD><TD>2.1</TD><TD>3.2</TD><TD>0</TD><TD>0.4</TD></TR><TR><TD>5678</TD><TD>3.3</TD><TD>1.2</TD><TD>5.7</TD><TD>0.2</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 border="1"><TBODY><TR><TD>Test ID</TD><TD>Active 1&nbsp;</TD><TD>Active 2&nbsp;</TD><TD>Active 3</TD><TD>Active 4&nbsp;</TD></TR><TR><TD>1234</TD><TD>Not tested</TD><TD>0.3</TD><TD>Not tested</TD><TD>Not tested</TD></TR><TR><TD>5678</TD><TD>Not tested</TD><TD>Not tested</TD><TD>2.3</TD><TD>Not tested</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 border="1"><TBODY><TR><TD>Test ID</TD><TD>Active 1&nbsp;</TD><TD>Active 2&nbsp;</TD><TD>Active 3</TD><TD>Active 4&nbsp;</TD></TR><TR><TD>1234</TD><TD>2.1</TD><TD><FONT color="#FF0000">0.3</FONT></TD><TD>0</TD><TD>0.4</TD></TR><TR><TD>5678</TD><TD>3.3</TD><TD>1.2</TD><TD><FONT color="#FF0000">2.3</FONT></TD><TD>0.2</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 08:24:58 GMT https://community.qlik.com/t5/QlikView/Mergining-data-sets/m-p/1845337#M1215441 mhamurcuoglu 2021-10-12T08:24:58Z