If Condition on date Column

Hey there

I have a column with date values and would like to create another column for an YTD (Year to date) analysis.
How can I use somehow a node with an “IF Condition” like this: If (Date<=“May”) than “YTD” else “budget”.
Any other help would be good!


Hi @FabioGuimaraes,

you could have a look at the Column Expressions node. It can be used to execute JavaScript snippets on each row of an input table. You could just write your IF statement and output a new column with the desired values.


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