I have an issue that should be solved urgently. The problem that I faced is merging to data sets. to describe better;
Data set 1 : This data set demonstrates first test results each ID
Test ID
Active 1
Active 2
Active 3
Active 4
1234
2.1
3.2
0
0.4
5678
3.3
1.2
5.7
0.2
Data set 2 : This data set demonstrates second test results of Active 2 for Test ID 1234 and second test results of Active 3 for Test ID 5678 .
Test ID
Active 1
Active 2
Active 3
Active 4
1234
Not tested
0.3
Not tested
Not tested
5678
Not tested
Not tested
2.3
Not tested
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.
Test ID
Active 1
Active 2
Active 3
Active 4
1234
2.1
0.3
0
0.4
5678
3.3
1.2
2.3
0.2
Thank you in advance, I'll be appreciated if anyone can support me to find a solution.
