topic Re: SQL Load ODBC Tables in QlikView

SQL Load ODBC Tables

craig157 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I'm currently working on pulling data from Filemaker to Qlikview using an ODBC connection.

Unfortunately our Filemaker Tables are shockingly named and poorly formatted so struggling to find certain fields.

Basically my question is; I want to LOAD * for a couple tables, but then there is some that I only want some fields.

When I run this I receive an error for the Specified Table "SQL SELECT."_OrgID"..."

It looks like below:

Organisation:

LOAD *;

SQL SELECT *

FROM "Organisation";

OrganisationHistory:

LOAD

[_OrgID] AS OrgId,

[Type],

[Complete],

[CreatedBy],

[Note],

[ActionDateStart],

[Hot_Warm];

SQL SELECT "_OrgID", "Type", "Complete", "CreatedBy", "Note", "ActionDateStart" "Hot_Warm"

FROM "Org to History";

Any ideas? Or do you have to be specific or * for all tables.

Cheers

Re: SQL Load ODBC Tables

Anonymous — Mon, 14 Aug 2017 15:05:39 GMT

does the sql select work without QlikView?

Re: SQL Load ODBC Tables

Anil_Babu_Samineni — Mon, 14 Aug 2017 15:11:52 GMT

OrganisationHistory:

LOAD

Load "_OrgID" as OrdId

SQL SELECT "_OrgID", "Type", "Complete", "CreatedBy", "Note", "ActionDateStart" "Hot_Warm"

FROM "Org to History";

May be use this?

Load "_OrgID" as OrdId

Re: SQL Load ODBC Tables

kamielrajaram — Mon, 14 Aug 2017 15:13:39 GMT

Hi,

There seems to be a comma missing before "Hot_Warm".

Re: SQL Load ODBC Tables

craig157 — Mon, 14 Aug 2017 15:14:54 GMT

Uhoh.. better go check this haha...

Re: SQL Load ODBC Tables

Anonymous — Mon, 14 Aug 2017 15:15:41 GMT

that's why my question...

Re: SQL Load ODBC Tables

craig157 — Mon, 14 Aug 2017 15:44:17 GMT

Believe it or not; that made no difference! How strange

Re: SQL Load ODBC Tables

Anonymous — Mon, 14 Aug 2017 15:46:09 GMT

does

SQL SELECT "_OrgID", "Type", "Complete", "CreatedBy", "Note", "ActionDateStart" "Hot_Warm"

FROM "Org to History";

without QlikView?

Try any other tool for your database.