Pick data between variable

KNIME Analytics Platform
#1

Hi All,
I would like to filter only previous month data .
That key column is string such as “20200701” format.

I would like to use variable such as From:20200701 and To :20200731.
How can I capture data between this variable?

I tried using raw based filter with
Key column >=“From” AND Key column =<“To” => TRUE

However, it did not work.

I would appreciate your help .
Thank you.

#2

Hi @erisu -

Here you should convert your dates from String format to native Date&Time using the String to Date&Time node. Then, you can use a Date&Time-based Row Filter to select records within a particular range.

1 Like
#3

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