Hi All,
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.
Regards
Mehmet
