Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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,
use where column is not null
if ur loading from database
Can you please elaborate?
try in where column1 is not null
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,
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!