I need to load a very big table in my qlik sense desktop. This table is twenty milions row made and load process go to error. I need to load only record from date "x" to date "y" instead of all table.
Can you help me?
Can I use a "where" status to load only date that I need?
where datefield > '2018/05/05';
"datefield" shouldn't be a fonction, its the date field in your data that has same format as the comparisaon (the '2018/05/05' part)
this stongly depends on date/time format in field TS_RUNTIME_START
are you sure about the format of your date in TS_RUNTIME_START field corresponds to '2018/05/05 00:01:01'?
try this first (without the time part) and see how it reacts:
where date(TS_RUNTIME_START,'YYYY/MM/DD') > '2018/08/05';
then try timestamp fonction;
if possible please provide sample data in excel.
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.