Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Just a quick observation but you seem to be missing the .qvd off the file name in the second load.
Chris
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
Thank you Chris,
Yes this did help. I also had a field that seemed to be invalid
Thank you