Joining Oracle and Excel data source

[#1]

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]

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