Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need to create flags for a column "Customer" in script.
Requirement is like if the "Customer" column is null in current year then the current year null flag =1 else 0
Similarly i need to look check for previous Year means if the "Customer" name is null in previous year then the previous year null flag will be 1 else 0.
I have to derive these flags to use in other field derivation in script.
Can somebody help me on this.
Thanks in advance
Regards,
Nani
if Customer and Year field both are in the same table then
if(len(trim(Customer))<1,1,0) as Flag
, else please post a sample