topic Re: General Script Error in QlikView

General Script Error

Thu, 09 May 2013 09:35:49 GMT

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.

Re: General Script Error

Thu, 09 May 2013 09:43:21 GMT

Hello Abhishek,

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

Angad

Re: General Script Error

Thu, 09 May 2013 09:46:42 GMT

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

Re: General Script Error

Thu, 09 May 2013 09:46:50 GMT

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

Re: General Script Error

calvindk — Thu, 09 May 2013 09:49:37 GMT

Or just drop table 1 before you create table 4

Re: General Script Error

Thu, 09 May 2013 09:50:16 GMT

yups that will also do.

Re: General Script Error

kaushiknsolanki — Thu, 09 May 2013 09:54:34 GMT

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