how to remove rows

[Anonymous]

Hi all i have a field name product

data like

-

baby

200

350

-

-

-

how to remove empty rows

[sunny_talwar]

May be use Where function

LOAD ...

FROM ..

Where Len(Trim(product)) > 0;

[balabhaskarqlik]

Product:

Load

ProductID,

Len(Trim(Product)) > 0 as Product,

ProductGroup

from Product

group by ProductID;

Or

Product:

Load

Product,

ProductGroup

From Product where Len(Trim(Product)) > 0;