Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
If(right(Codes,1)=3,'Y','N') as Flag
May be this:
LOAD Codes,
dates,
If(Codes = 'A3', dates) as New_Dates,
If(Codes = 'A3', 'Y', 'N') as Flag
FROM Source;
If(right(Codes,1)=3,'Y','N') as Flag
Thanks Digvijay