How to Replace the title of OCT 2017 with '1' etc.

  OCT 2017 NOV 2017 DEC 2017 JAN 2018 FEB 2018
A 0 0 0 0 24
B 73 2 0 8 0
C 0 62 0 0 0
D 0 0 12 6 0
E 0 0 0 0 0
F 73 0 0 0 0

I would like to set up a process to fiter N1-2M >10 or N3-4M >20's letter, i am not sure how to write it. It is the same function of 'offset' and 'condition format' in excel, but i would like to ask help of how to write, thanks ahead! 

Hi Vicky,

I suggest you use the Rule-based Row Filter node for this. Offsetting like you do is not supported, so you have to specify the columns you want to use for filtering explicitly.

Cheers,

Roland

Hi Roland,

thanks a lot! Now i use this function to filter, but i still wanna find a way to be more automatic :)

BR,

Vicky

Hi Vicky,

If you post your current workflow with some example data, I can have a look if there is something that can be made easier.

Cheers,

Roland

Hi Roland,

Appreciate your help, please find the attachment. i wanna find a way to replace the month by putting date or number in KNIME instead of modify month name each time. 

Thanks!

Vicky