Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
xaiver-m
Contributor
Contributor

Extra rows after WHERE Clause in Load

I am new to Quiksense and have dabbled around with importing an excel sheet with data into the system. The excel had a large number of rows with a unique ID to each. 

To reduce the dataset, I applied filtering techniques such as adding a `WHERE` clause in the Data Load Manager after my excel sheet is uploaded. My query seems semantically and logically correct and loads with no error.

However, when I enter the Data Model Viewer, the number of rows increased (original number of rows + number of filtered rows by the `WHERE` clause. Am I missing something? 

Labels (3)
5 Replies
Channa
Specialist III
Specialist III

it might have loading two times check your script 

any auto generated script delete it use the one with where clause 

Channa
xaiver-m
Contributor
Contributor
Author

Thanks Channa, do you mind pointing me to some resources to do so?

I did see some people using this, but couldn't implement it for myself.

MYDATA:
LOAD ...
....

WHERE ....;

DROP TABLE MYDATA;
Channa
Specialist III
Specialist III

check any extra tabs in your data load 

or only one tab

if one tab you dont need to drop

Channa
xaiver-m
Contributor
Contributor
Author

I don't recall seeing two tabs. I have only one excel imported and used the default script provided in the Data Load Editor and added my own WHERE clause to it.
Lauri
Specialist
Specialist

Check the Data Manager for two versions of the Excel sheet. Or, better yet, modify your data load script to pull directly from the Excel file in its original location instead of the copy that is attached to your Qlik app. This requires a simple data connection to the folder where the Excel file sits. I find it much clearer to work with files that way than to attach them (via drag and drop).