Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Load * Inline
[
Customer, Sales
, 100
L, 120
C, 140
, 200
] Where IsNull(Customer) or Len(Trim(Customer))= 0;
Load * Inline
[
Customer, Sales
, 100
L, 120
C, 140
, 200
] Where IsNull(Customer) or Len(Trim(Customer))= 0;
HI
Try like this
Customer:
Load
customer,
Id where Len(Trim(customer)) =0;
sql select * from customer;
Thank you very much Manish Kachhia.
it is working fine.
Thank you very much Mayil Vahana Ramasamy,
it is working fine.