Hey everyone, I’m just started doing a project and I am stuck at data manipulation section. I have a couple of questions for you and I would be more than happy if I could get some help on these. question 1) I want to create a math formula with if function. Basically what I want to do is: Add rows Servicemonth+1 if servicemonth<=Age*12 Name Surname Age ServiceMonth A B 60 715 C D 60 718 Name Surname Age ServiceMonth A B 60 715 A B 60 716 A B 60 717 A B 60 718 A B 60 719 A B 60 720 C D 60 718 C D 60 719 C D 60 720 question 2) I have a variable that calculates number of months of the year that I worked on the project. I want to see when I started the project by adding a new column that reduces the number of months from the date I have. There are also finished projects so not all data is current date. For example: How can I reduce 35 months from 01.05.2020 and get a date?

Hi, What about this KNIME_project KeremErkmen II.knwf (54.8 KB)

I am doing a project and I have a quick question

ipazin November 5, 2020, 9:58am 17

Hello there!

@KeremErkmen considering you are coming from Alteryx here is a topic to check:

Br,
Ivan