Loading empty rows

[macdonaldm]

Hello, When I load my data one of my tables is loading 999 rows, 989 of which are empty. Do you know how to stop this from loading? They are set as nulls, but it seems to still affect my data

[Channa]

use where column is not null

if ur loading from database

[macdonaldm]

Can you please elaborate?

[Channa]

try in where column1 is not null 

[PrashantSangle · Accepted solution]

Can you explain about little bit more??

what is you source data??

is your all fields in that rows are empty?

can you post your script here?

as @Channa suggested use where clause to restrict load.

like 

Load * 

from tableName 

where len(trim(FieldName1))>0;

Regards,

[macdonaldm]

Uploading from an excel spreadsheet that is uploaded to qlik cloud, and then the app pulls the data from there. SO the table I'm having trouble with looks like this:

LOAD
"Sale Key",
"Year",
"Month",
Customer,
"Service Type",
"Sale Info",
"Team Member",
"Sale Amount"
FROM [lib://qlikid_macdonald.meghann/Master Sales Data Sheet DRAFT.xlsx]
(ooxml, embedded labels, table is [Sales Closed]);

And then is loading 999 rows, even though 989 of the rows are completely empty. I tried clearing all the formatting/data validation/ etc before uploading. where does the len(trim(FieldName1))>0; go? 

EDIT: All set, I put that function before the ; and it solved the problem. Thank you!