If Condtions

[upaliwije]

Hi Friends,

I want to write following condition in may data load script

IF(QUOTED_PRICE<AVG_PRICE AND IF(QUOTED_PRICE<MARKET_PRICE AND IF(QUOTED_PRICE< LAST_PURCHASE,'Y','N'))) AS PURFLG,

But it is not correct. Kindly help me

[Arthur_Fong · Accepted solution]

Try:

IF(QUOTED_PRICE<AVG_PRICE AND QUOTED_PRICE<MARKET_PRICE AND QUOTED_PRICE< LAST_PURCHASE,'Y','N')as PURFLG

[upaliwije]

Thanks