topic Re: incremental load in QlikView

incremental load

Anonymous — Thu, 25 Feb 2016 17:18:07 GMT

Hi,

I am doing incremental load.

I have done

table1:

load * from table1;

store table1 into table1.QVD

table2:

load * from table2;

store table1 into table2.QVD

Here table1.QVD got created successfully and table2.QVD not created. If I place table2 in first place and table1 in second place, table2.QVD got created. table1.QVD not getting created. I don't second table qvd not able to creating.

Any ideas to resolve the issue.

Regards,

Kumar

Re: incremental load

johnw — Thu, 25 Feb 2016 17:23:41 GMT

I'm guessing you had a slight typo above, and did this:

table1:

load * from table1;

store table1 into table1.QVD;

table2:

load * from table2;

store table2 into table2.QVD;

And I'm guessing you have the same fields in both tables. If so, without a NOCONCATENATE on the second load, it will actually concatenate the fields onto the first table, ignoring the name you gave. So when you try to store, there is no table2 to store, and I'd expect you to get an error in your script at that point saying your table doesn't exist.

But I could easily have misunderstood the problem, particularly when I'm answering a question on code different from what you posted.

Re: incremental load

Anonymous — Thu, 25 Feb 2016 17:31:21 GMT

Hi John,

For your quick reply. Sorry for typo error and in two tables I am having almost 9 columns are in common and rest of the columns are different.

I tried with NOCONCATENATE

table1:

load * from table1;

store table1 into table1.QVD

NOCONCATENATE

table2:

load * from table2;

store table2 into table2.QVD

But no use.

Re: incremental load

johnw — Thu, 25 Feb 2016 17:40:35 GMT

The NOCONCATENATE goes between the table name and the load, but as long as the rest of the columns are different, my explanation and that solution are incorrect. That isn't the problem. I'm not sure I could diagnose better without seeing more of the script, but here's a working script of almost exactly the same form with nine columns the same and two different.

table1:
LOAD * INLINE [
A,B,C,D,E,F,G,H,I,J,K
1,2,3,4,5,6,7,8,9,A,B
C,D,E,F,G,H,I,J,K,L,M
];

STORE table1 INTO table1.qvd (QVD);

table2:
LOAD * INLINE [
A,B,C,D,E,F,G,H,I,L,M
1,2,3,4,5,6,7,8,9,A,B
C,D,E,F,G,H,I,J,K,L,M
];

STORE table2 INTO table2.qvd (QVD);

Re: incremental load

engishfaque — Fri, 26 Feb 2016 07:31:41 GMT

Dear Kumar,

Use "store table2 into table2.QVD;" instead of "store table1 into table2.QVD;"

Please go through incremental load article from listed below link,

http://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/

Incremental Load in QlikView – Part1 | Learn QlikView

Kind regards,

Ishfaque Ahmed

Re: incremental load

Anonymous — Fri, 26 Feb 2016 08:32:13 GMT

Hi,

Thanks for sharing valuable information.It was typo error.

I did perfectly,but no use.