Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
craig157
Contributor

SQL Load ODBC Tables

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

7 Replies
robin_hausdoerfer
Valued Contributor III

Re: SQL Load ODBC Tables

does the sql select work without QlikView?

Re: SQL Load ODBC Tables

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
kamielrajaram
Contributor III

Re: SQL Load ODBC Tables

Hi,

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

craig157
Contributor

Re: SQL Load ODBC Tables

Uhoh.. better go check this haha...

robin_hausdoerfer
Valued Contributor III

Re: SQL Load ODBC Tables

that's why my question...

craig157
Contributor

Re: SQL Load ODBC Tables

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

robin_hausdoerfer
Valued Contributor III

Re: SQL Load ODBC Tables

does

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

FROM "Org to History";


without QlikView?


Try any other tool for your database.