topic RE:Loading QVD in QlikView

RE:Loading QVD

kamielrajaram — Thu, 21 Apr 2011 10:19:59 GMT

Good day Guru's

I have created a script to load history qvd's into one qvd for specific days of the month. This works fine. When I load from the main qvd into two separate tables, one containing opening data and one contaning closing data and then try to create my final history qvd, I get the error cannot find table.

table1:

load x,y,z from test.qvd;

table2:

load a,b,c,x from test;

table3:

load * resident table1;

left join

load * resident table2;

store table3 into path;

thank you in advance

RE:Loading QVD

chris_johnson — Thu, 21 Apr 2011 11:11:41 GMT

Hi,

Just a quick observation but you seem to be missing the .qvd off the file name in the second load.

Chris

RE:Loading QVD

chris_johnson — Thu, 21 Apr 2011 11:13:59 GMT

Oh hang on!

On your third load statement where you are doing load * resident table2 you need to change this to:

noconcatenate load * resident table2.

QlikView takes tables that have the same field names and just loads everything into the first table so you have to either use NOCONCATENATE or change the field names

Chris

RE:Loading QVD

kamielrajaram — Thu, 21 Apr 2011 12:17:07 GMT

Thank you Chris,

Yes this did help. I also had a field that seemed to be invalid

Thank you