Selection of Product using various rules

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! :slight_smile:


has to work for the task.

5 Likes

Hi ravi13,

as izaychik63 told - i thin the Rule based row filter does exactly what you want.
Here a short example:
Example_.knwf (3.7 KB)

but you have to make sure that the value is really exactly equal e.g. an extra space in one column will be seen as different values

3 Likes

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.