Skip to main content
To homepage To homepage
Solved

Implementing SQL "CASE WHEN" Statement using native TX functionality

M
Starter
  • mcv
  • Starter
  • 1 reply

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

Best answer by jens.mikkelsen

Hi Michael.

 

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

 

View original
Did this topic help you find an answer to your question?

2 replies

J
Contributor

Hi Michael.

 

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

 

M
Starter
  • mcv
  • Author
  • Starter
  • 1 reply
  • April 8, 2020

Hi Jens,

That worked, thank you.

Best regards

Michael Vaisgaard

Reply


Most helpful members this week

Terms and ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings