Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
it might have loading two times check your script
any auto generated script delete it use the one with where clause
check any extra tabs in your data load
or only one tab
if one tab you dont need to drop