Need help on Match or Compare columns expression

KNIME Analytics Platform
1

Hello Team, Please help on the below business case

I i have 3 columns , 1 and 3 are the Date columns and 2 is the text columns.
1 column (XYZ Date column) in Base file. 3 (XYZ Date column) and 2 (Text column - any defined text ) in the source file.
Now i want Base file 1st Date column should match/compare with Source file 2 column and then 3rd column of same employee and then give us the True or False result under column expression node. IT should match text first and then date and then give us the comparison result. Sample example are as below
column("XYZ Date (1) ") == column(“XYZ Date (3)”)[column(“Text column (2)”) == “Test Pass”]
it should give us result matching Test Pass text of Text column and then match 3 date column

2

Let’s see if this workflow responds to your question.

Best.

2 Likes
3

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