If right function

[Anonymous]

Hi guys

Abit stuck on this

I wanted something like

My data shows dates and codes

Codes are A1, A2, A3 etc

I want A3 to say Y and others to say N

If (right = 3, then show date)

Thanks

Adil

[sunny_talwar]

May be this:

LOAD Codes,

          dates,

          If(Codes = 'A3', dates) as New_Dates,

          If(Codes = 'A3', 'Y', 'N') as Flag

FROM Source;

[Digvijay_Singh · Accepted solution]

If(right(Codes,1)=3,'Y','N') as Flag

[Anonymous]

Thanks Digvijay