NULL

[ankitaag]

T:

Load * INLINE [

A,B,C

,1,

2,2,3

,,

];

T2:

Load A,B,C,'' as junk

Resident T

where A<>'' and B<>'' ;

drop table T;

[dineshsingh · Accepted solution]

T:

Load

*

INLINE [

A,B,C

,1,

2,2,3

,,

];

T2:

Load

  A,

  B,

  C,

  '' as junk

Resident T

Where not (A=''

and B=''

and C='');

Drop Table T;

[ahaahaaha]

Hi Ankita,

Forgive me, did not understand, but what did you want to receive? Result in the attached file.

Regards,

Andrey

[beck_bakytbek]

can you explain what do you achieve to expect by that?

[ankitaag]

Hi,

Apologies for the incomplete question.

I want to ignore the row having all blank values. so as a result i want only 1st and 2nd row.

But the condition where A<>'' and B<>''  and C<>''; doesn't work, however the condition mentioned by Dinesh

not (A='' and B='' and C=''); works. Can anybody explain why?

Thanks and Regards,

Ankita

[beck_bakytbek]

Hi Ankita,

you can convert the blank value into Zero and alter exclude them

look at this post: https://www.youtube.com/watch?v=l20fjOQgbRc

i hope that helps