Our production machine does a final test of every assembled product. It tests a lot of features and attributes with different but unique ID’s. Unfortunately the machine writes the results of in groups to the database. Therefore I have two datasets for one test, but it is within a gap of max. 1min.
If there is a recurring test necessary it takes minutes for the new datasets.
Time | ID | Feature 1 | Feature 2 | Feature 3 | Feature 4 | Feature 5
7:03:18 | 1 | ? | ? | 0 | 1 | 0
7:03:32 | 1 | 1 | 0 | ? | ? | ?
How can I combine these datasets? Time should be the last timestamp. If it is from the same test, there is no intersection with the features.
Thanks for your help to a knime rookie.