General Script Error

[#1]

Hi I'm trying to load a few tables from the db as well as creating and loading from qvd files in the same script. The problem is when I created and loaded only 1 qvd file it was running perfectly. However when i created 2nd table and stored it into another qvd file it gives an error saying 'Table4 not found' (Table4 is my 2nd table).

I have attached the log file.

[#2]

Hello Abhishek,

Did you check the Table Viewer and can you find Table4 there?

Angad

[#3]

Hello Abhishek,

It is due to same column names being used in Table1 and Table4. Qlikview concatenates the data automatically if the column names are same.

If you see your table viewer, you will find only Table1 created.

So change the column names of SQL for Table4 and it will work.

Thanks

Angad

[#4]

Yes i checked the table viewer and it's not there.

[calvindk]

Or just drop table 1 before you create table 4

[#6]

yups that will also do.

[kaushiknsolanki]

Hi,

    This is because the table1 and table4 contains the same numbers of fields and the field names are same.

    IN this condition QlikView will by default concatenate the second table into first. So in your case the Table4 is getting concatenated in Table1 and thus there is no Table4.

    So you are getting the error saying there is no Table4.

     All you have to do is after storing the table1 in Qvd you can drop that using the statement

     Drop table Table1.

     Or you can use the noconcatenate keyword before the load statement of table4.

     Somthing like

     noconcatenate sql select * from xyz;

Regards,

Kaushik Solanki