Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mhamurcuoglu
Contributor III
Contributor III

Merging Data

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

Labels (2)
0 Replies