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,


UzftzokLe38mYsD3Kt0d6A.png


Hi Jens,


That worked, thank you.


Best regards


Michael Vaisgaard


Reply