help needed to derive flag in script

[#1]

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

[vinieme12]

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