Four Stars

[resolved] Set cell value based on value in other column

Hi,
I was looking for this option but cannot find any suitable function for this operation. Is the operation supported in the current implementation? 
Equivalent in Excel: if function
Equivalent in Sql: case when statement

1 REPLY
Employee

Re: [resolved] Set cell value based on value in other column

Yes a similar function is on the roadmap.
In the meantime, some functions can be used to deal with conditions such as compare or match. They will generate a decision i.e true/false, you can then filter on true and apply a function on this subset.