Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Adam12
Contributor
Contributor

Table not found error

Hello,

I'm encountering an error when trying to load data and store into QVD files from two separate databases.

In the load script I've got two tabs with the DB connection string and then the following syntax:

JournalsDB1:

LOAD
Column 1,
Column 2,

Column 3,

Column 4,

Column 5,

Column 6,

Column 7;

SQL SELECT *
FROM DB1.dbo.vwDBJournal;

STORE JournalsDB1 INTO QVDs\JournalsDB1.qvd (qvd);

and then in the second tab - 

JournalsDB2:

LOAD
Column 1,
Column 2,

Column 3,

Column 4,

Column 5,

Column 6,

Column 7;

SQL SELECT *
FROM DB2.dbo.vwDBJournal;

STORE JournalsDB2 INTO QVDs\JournalsDB2.qvd (qvd);

The script loads and stores the data fine for the first tab but then for the second tab, it doesn't work and states 'Table not found' which is strange as when trying this separately for the second database, it loads the data and stores it without any issues.

I've managed to work around it by concatenating the data from both databases in one tab but I've used the above method in the past, so I'm wondering why it might be failing now.

Any suggestions or help would be appreciated.

Many thanks

1 Reply
mfchmielowski
Creator II
Creator II

Hi

This is qlik feature. If yours two loads have the same column number and names qlik will concatenate thouse two tables into the first one.

In your case drop the first table after store statement or use noconcatenate statement before loading second table.