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


Reply