Skip to main content

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

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