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

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

mertez — Sat, 16 Nov 2024 10:47:33 GMT

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

Anonymous — Thu, 18 Feb 2016 15:15:18 GMT

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.