How to write IF Statement in Yellowfin?

Siva Ramakrishna shared this question ago

Answered

Hi Team,

I am trying to find IF statement to use in Yellowfin.

Can you please insert below statement and let me know:

Eg:

IF(Days To Process ="","",IF(Days To Process >2,FAIL,PASS))

Note: I have added this statement in a Calculated field directly and have click on validate button. It shows SQL is valid. But when I drag and drop into the Yellowfin canvas, there is no result.

Thanks,

Ram Krishna

Files:

The same question

Replies (2)

Nathan Schroeder ●

Hi Siva,

In SQL, if-> else statements are known as case->when statements:

https://www.w3schools.com/sql/func_mysql_case.asp

You can build these in the calculated field builder, as well as freehand sql statements.

Regards,

Nathan

Reply URL

Nathan Schroeder ●

Hi Siva,

I am going to set this ticket to closed for now, but if there is anything else I can do to help here, please just let me know and the case will be re-opened!

Regards,

Nathan

Reply URL