Hi !! Knime Expert
Hope you are fine.
I just need your help to DEVELOP WORKFLOW TO find correcT product using required rule.
Input Data:
Product | date 1 | date 2 | date 3 | type 1 | type 2 |
---|---|---|---|---|---|
A | 15-06-2015 | 15-06-2015 | 15-06-2015 | 2001 | 2001 |
B | 16-06-2015 | 16-06-2015 | 18-06-2015 | 101 | 101 |
C | 18-06-2015 | 18-06-2015 | 15-06-2015 | 555 | 555 |
D | 20-07-2015 | 20-07-2015 | 20-07-2015 | 101 | 555 |
Requirement:
Find product where Date 1 = Date 2= Date 3 & type 1 = type 2
Here both the requirement should be fullfilled.
Output:
Product | date 1 | date 2 | date 3 | type 1 | type 2 |
---|---|---|---|---|---|
A | 15-06-2015 | 15-06-2015 | 15-06-2015 | 2001 | 2001 |
Thanks in Advance!