Solved

Implementing SQL "CASE WHEN" Statement using native TX functionality

Hi,

I have to do something like this in TX:

If productno > 0 then 'Product A'

else lookup in table productnames

I cannot figure out how to do this in TX.

Hope someone can help.

Best regards

Michael Vaisgaard

icon

Best answer by jens.mikkelsen 6 April 2020, 11:37

Hi Michael.

You just do a field transformation on the lookup field (with a condition), could look like this,

Hi Jens,

That worked, thank you.

Best regards

Michael Vaisgaard

Sign up