topic Re: Link Oracle and Excel in QlikView

Link Oracle and Excel

nuntius007 — Fri, 16 Sep 2016 14:26:00 GMT

I have the following queries and I cannot link them. Can someone show me how to do it?

Regards.

UploadStats:

SQL Select

(to_number(to_char(UPLOAD_DATE, 'DD')) || to_number(to_char(UPLOAD_DATE, 'MM')) || to_number(to_char(UPLOAD_DATE, 'YYYY'))) as Keyfield,

INSTANCE_ID,

ENVIRONNEMENT

from My.OracleTable

Climat:

LOAD

([Day] & [Month] & [Year]) as Keyfield,

[Temp (°C)], [Temp Indicator]

FROM

(biff, embedded labels, table is [fre-hourly$]);

Re: Link Oracle and Excel

Gysbert_Wassenaar — Mon, 19 Sep 2016 06:55:51 GMT

That's probably because the load from oracle will create a field called KEYFIELD instead of Keyfield. Try adding double quotes around the alias:

UploadStats:

SQL Select

(to_number(to_char(UPLOAD_DATE, 'DD')) || to_number(to_char(UPLOAD_DATE, 'MM')) || to_number(to_char(UPLOAD_DATE, 'YYYY'))) as "Keyfield",

INSTANCE_ID,

ENVIRONNEMENT

from My.OracleTable

Re: Link Oracle and Excel

sasikanth — Mon, 19 Sep 2016 07:19:02 GMT

Also try to Store ORACLE table into a QVD and then load this QVD into your application.

Re: Link Oracle and Excel

jagan — Mon, 19 Sep 2016 07:32:11 GMT

Hi,

Oracle select statement will create the columns in Upper case, to bypass this you need to enclose column in double quotes or use preceding load.

UploadStats:

SQL Select

(to_number(to_char(UPLOAD_DATE, 'DD')) || to_number(to_char(UPLOAD_DATE, 'MM')) || to_number(to_char(UPLOAD_DATE, 'YYYY'))) as "Keyfield",

INSTANCE_ID,

ENVIRONNEMENT

from My.OracleTable

Climat:

LOAD

([Day] & [Month] & [Year]) as Keyfield,

[Temp (°C)], [Temp Indicator]

FROM

(biff, embedded labels, table is [fre-hourly$]);

UploadStats:

LOAD

KEYFIELD AS KeyField,

INSTANCE_ID,

ENVIRONNEMENT

SQL Select

(to_number(to_char(UPLOAD_DATE, 'DD')) || to_number(to_char(UPLOAD_DATE, 'MM')) || to_number(to_char(UPLOAD_DATE, 'YYYY'))) as Keyfield,

INSTANCE_ID,

ENVIRONNEMENT

from My.OracleTable

Climat:

LOAD

([Day] & [Month] & [Year]) as Keyfield,

[Temp (°C)], [Temp Indicator]

FROM

(biff, embedded labels, table is [fre-hourly$]);

Hope this helps you.

Regards,

Jagan.

Re: Link Oracle and Excel

nuntius007 — Mon, 19 Sep 2016 12:30:04 GMT

Double quotes did work!

Thank you everyone.

Regard!

Re: Link Oracle and Excel

jagan — Tue, 20 Sep 2016 08:42:41 GMT

Hi,

Instead of giving Assumed Answered you would give Correct and Helpful answers to the posts which helps you. It encourages others to give answers and also easier to find answers for others.

Regards,

Jagan.