Hi Guys, My sample file has 27 columns with INT and Chararray data types. My requirement is to filter out all the null values which are present in these columns What I am trying to do is this, Sample_fil = FILTER Adzone by (Div is not null) and (Zone_yak is not null) and (ProdGroup is not null) and (Zonename is not null) and (Store_fruit is not null) and (Comp_Zone is not null) and (Department is not null); This script is only for the first 7 columns only. I can write the same script even for the rest of the columns but I am looking for a way to optimize the script. My sample file has 12 Integer datatype and the rest are Chararray. Please give your suggestions. Regards, Pradeep. ... View more