[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
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.