Date Range Filter

KNIME Analytics Platform
1

Hello Team, We have Date column in the xlsx file in the format of yyyy-mm-dd , i need a solution to filter only the previous month data range. Example, if you are running flow in Feb it should filter Jan data and save in the excel writer node

Month Name Amount
01-01-2025 123 456789
02-12-2024 ABCD EFGG
02-01-2025 123 456789
02-12-2024 ABCD EFGG
02-12-2024 123 456789
02-01-2025 ABCD EFGG
01-01-2025 123 456789
01-01-2025 ABCD EFGG
02-01-2025 123 456789
02-12-2024 ABCD EFGG
02-12-2024 123 456789
01-01-2025 ABCD EFGG
2

Hi Madhu,
I have designed a simple flow to achieve this output. I have inserted a string manipulation node which runs inside loop to check and compare 2 column scenarios to consider current month name and previous month name.

image
image1157Ă—256 15.7 KB

KNIME_Node_C_P
KNIME_Node_C_P867Ă—966 42.6 KB

KNIME_solun_C_P3

You could filter out only “Consider” status using “Row Filter” node and export it to Excel writer.

5 Likes
3

Another solution here:

Extract year and month from executing time and the data, then filter the data with last month.

1 Like