Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

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

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.

4 Replies
MVP
MVP

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

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.

Not applicable

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

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.

MVP
MVP

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

Hi,

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


Regards,

Jagan.

Not applicable

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

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

Community Browser