How to connect multiple app(same content) to multiple OLE DB (identical)

[#1]

hi guys,

can you please help me on this, how to load the three tables, fields are identical the only difference is the content because it was transact with different location. and create app(same format) in each table.

thank you.

[jagan]

HI,

Try like this

ODBC CONNECT DataSource1;  // Open Datasource1 connection and load the data

TableName:

SELECT *,

'DataSource1' AS Datasource  // Flag field to identify the data source

FROM TableName;

ODBC CONNECT DataSource2;  // Open Datasource2 connection and load the data to the existing table

Concatenate(TableName)

SELECT *,

'DataSource2' AS Datasource // Flag field to identify the data source

FROM TableName;

ODBC CONNECT DataSource3;  // Open Datasource3 connection and load the data to the existing table

Concatenate(TableName)

SELECT *,

'DataSource3' AS Datasource  // Flag field to identify the data source

FROM TableName;

Hope this helps you.

Regards,

Jagan.

[#3]

hi jgan,

thanks for the reply. will try and get back to you if its work. just at question is ODBC Connect is not the same with LIB CONNECT?

Thank you.

[jagan]

Hi,

ODBC CONNECT is in Qlikview, use corresponding in Qliksense, I do not have Qliksense installed to try.

Regards,

Jagan.

[#5]

Hi Jagan,

Thanks for the reply again. I will try if it works because in Qliksense desktop the connect statement is LIB.

Best regards,

Yhen