How to exclude valuesbefore loading data

[Lucky1]

Hi

i have a table i want to exclude if name and status have nulls.

I

i want output like

[Kushal_Chawda]

@Lucky1  try below

LOAD ID,
     Name,
     Status
FROM Table
where len(trim(Name))<>0 or len(trim(Status))<>0

[BrunPierre]

Hi, like this.

LOAD ...
FROM SourceTable
Where Len(Trim(Name&Status));