Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
i have a table i want to exclude if name and status have nulls.
I
i want output like
@Lucky1 try below
LOAD ID,
Name,
Status
FROM Table
where len(trim(Name))<>0 or len(trim(Status))<>0
Hi, like this.
LOAD ...
FROM SourceTable
Where Len(Trim(Name&Status));