topic Joining Oracle and Excel data source in QlikView

Joining Oracle and Excel data source

Fri, 18 Oct 2013 17:22:38 GMT

Hi,

I am trying to join an Oracle data source and an excel data source. How can I do this in QlikView script?

By 'join' I mean combining columns from the two data sources based on a common key column.

Any help will be greatly appreciated.

Thank you,

Viral Mehta

Anonymous — Fri, 18 Oct 2013 17:35:41 GMT

Hi Viral,

Yes, it is joining... If the primary source is Oracle, and Excel is for adding columns:

CONNECT... // connect string for Oracle

Data:
SQL SELECT
Key,
A,
B,
...
FROM MyOracleTable;

LEFT JOIN (Data) LOAD
Key,
X,
Y
FROM <whatever your wizard will built here for Excel>

Regards,
Michael