topic Invisible tables in ODBC connection in QlikView

Invisible tables in ODBC connection

Mon, 18 Jan 2010 14:31:10 GMT

Dear All,

I've prepared a qv report that sources data from sql tables through two ODBCs i.e:

ODBC1

SQL database 1 CONCATENATE

SQL database 2 CONCATENATE

SQL database 3 CONCATENATE

ODBC2

SQL database 4 CONCATENATE

SQL database 5 CONCATENATE

SQL database 6

For some reason only tables from ODBC1 are sourced, tables from second ODBC2 are omitted. I've swapped the order i.e. ODBC2 went before ODBC1 and then only tables from ODBC2 were sourced. No error is shown after reload.

Any idea how to fix it?

BR,

Przemek

Invisible tables in ODBC connection

spsrk_84 — Tue, 19 Jan 2010 06:55:41 GMT

Hi,

Check the cloud once the data is reloaded whether the tables what u got in data cloud contains data the data from both the ODBC connections,Since u r using the Concatenate Statement without any hint to which it has to be concatenated.else use this sort of syntax

load * from Xyz.qvd;

Concatenate(A)

Load * from Pqr.qvd;

Please let me know if u r not clear with what i said to u.........

Invisible tables in ODBC connection

Wed, 20 Jan 2010 17:22:30 GMT

I don't really know what you mean by data cloud - if this is all the data sourced by the script then there no records from the other ODBC dbs. I've changed to Concatenate (Tab) but still not working.

Any idea what else to do?

BR,

Przemek