Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
dgiannicola
New Contributor II

load table with many rows

Hi,

    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?

I use:

LOAD columnA,

          columnB,

          columnC;

Can I use a "where" status to load only date that I need?

Regars

Daniele

Tags (1)
8 Replies
kfoudhaily
Contributor III

Re: load table with many rows

true

load

a,

b,

c,

date

from .......

where date > '01/01/2017'

for exemple;

please provide more details, we might be able to help you with the syntax.

regards,

dgiannicola
New Contributor II

Re: load table with many rows

Hi Khalil,

     tx about information. My script is:

and if I call it from SQL develop I see:

Can you help me?

Regards

Daniele

kfoudhaily
Contributor III

Re: load table with many rows

load

     ...

from "soa...."

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)

dgiannicola
New Contributor II

Re: load table with many rows

I'll try this:

Error in load

Regards

Daniele

Re: load table with many rows

can you post your error screen shot also.

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
kfoudhaily
Contributor III

Re: load table with many rows

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:

load...

from...

where date(TS_RUNTIME_START,'YYYY/MM/DD') > '2018/08/05';

then try timestamp fonction;

if possible please provide sample data in excel.

dgiannicola
New Contributor II

Re: load table with many rows

this works!

Tx

Daniele

kfoudhaily
Contributor III

Re: load table with many rows

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.