Null values getting

[ravindraa]

hi i have one requierment i need to get only when customer is equal to zero.
The customer field have below value like

Customer

                                        <- this is the null value

L
C

                                         <- this is the null value

To get the Values based on the condition like below

in the edit script level i wrote below conditon

Customer:

Load
customer,
Id  where match(customer,'  ');

sql from customer;

Please give any suggesion one this.
Thanks for advance.

[MK_QSL · Accepted solution]

Load * Inline

[

  Customer, Sales

  , 100

  L, 120

  C, 140

  , 200

] Where IsNull(Customer) or Len(Trim(Customer))= 0;

[MayilVahanan]

HI

Try like this

Customer:

Load
customer,
Id  where Len(Trim(customer)) =0;

sql select * from customer;

[ravindraa]

Thank you very much Manish Kachhia.

it is working fine.

[ravindraa]

Thank you very much Mayil Vahana Ramasamy,
it is working fine.