Entering a specific date in Load Script Where Clause?

[jmcdermott]

Where

dt_start= 7/5/2018; // trying to pull all the data for only one date.

what the field output looks like when I run script (Without where clause) with First 1000  

Table 77 million records so trying to limit it.  When I click reload nothing happens

What am i doing wrong?

Thanks,

Josh

[olivierrobin]

hello

as usual with dates, verify the correct format

when i see

Where

dt_start= 7/5/2018; // trying to pull all the data for only one date.

i think Qlik considers the value as 7 divided by 5 divided by 2018

[Miguel_Angel_Baeyens · Accepted solution]

As Olivier points, use

WHERE dt_start = '7/5/2018';

With single quotes, and also make sure that M/D/YYYY is the format in which dt_start will display, else you will need to use the Date() function, like

WHERE dt_start = Date('05-07-2018', 'DD-MM-YYYY');

With the corresponding format

[jmcdermott]

Thanks Miguel and Olivier, the  WHERE dt_start = '7/5/2018'; worked.  It still took 9 mins to pull that one date's data  328K records from the QVD. I was expecting it to be a lot faster, is it because the table has 77M records?

[Miguel_Angel_Baeyens]

What else is the script doing? 9 mins could be a lot of time, but if the source QVD is 20GB, or if the file is located in a network far from the client or server performing the reload, or if the script is doing a preceding load and JOINs...

77 million rows, as such, is something you can easily load in your laptop. But again, if every row has 250 columns, and those columns are long texts, or numeric values with dozens of decimal positions, that would make a big difference.

Moreover, what else is going on on the computer which is performing the reload? That will also affect the reloading time.