Condition of 2 columns

Hi guys! Can someone please help me?

I have two data: month and year. I want to create a new column and do a condition like:

  • If its June, and its 2021, then the new column joining them will be “Fiscal Year 2122”

I tried a few nodes but none of them worked

Hi,
The best node for multi-column conditions is the Rule Engine.
Kind regards,
Alexander

1 Like