Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all i have a field name product
data like
-
baby
200
350
-
-
-
how to remove empty rows
May be use Where function
LOAD ...
FROM ..
Where Len(Trim(product)) > 0;
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;