I have a column that I want to set to Null based on condition on another column value.
I succeeded to build the formula but did not find the keyword for Null
if(and(isNotNull(myColumn) ,myOtherColumn!= 'VALUE'), NULL, myColumn)
For the moment I put '' instead, but this is not what I want.
Thank you for your answer,
Thank you Clément for your reply.
The issue is that the column is used later in the flow in a join reciepe and then the blank '' is different from Null (Database wise)