Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try:
IF(QUOTED_PRICE<AVG_PRICE AND QUOTED_PRICE<MARKET_PRICE AND QUOTED_PRICE< LAST_PURCHASE,'Y','N')as PURFLG
Try:
IF(QUOTED_PRICE<AVG_PRICE AND QUOTED_PRICE<MARKET_PRICE AND QUOTED_PRICE< LAST_PURCHASE,'Y','N')as PURFLG
Thanks