RE:Loading QVD

[kamielrajaram]

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

[chris_johnson]

Hi,

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

Chris

[chris_johnson]

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

[kamielrajaram]

Thank you Chris,

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

Thank you