Skip to main content
Question

CASE WHEN

  • April 6, 2020
  • 2 replies
  • 0 views
M
  • mcv
  • New Participant

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

    2 replies

    J
    Forum|alt.badge.img

    Hi Michael.

     

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

    UzftzokLe38mYsD3Kt0d6A.png

    M
    • mcv
    • Author
    • New Participant
    • April 8, 2020

    Hi Jens,

    That worked, thank you.

    Best regards

    Michael Vaisgaard

    Terms & ConditionsCookie settingsAccessibility statement