Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

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
Highlighted
Anonymous
Not applicable

does the sql select work without QlikView?

Highlighted

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)
Highlighted
Creator III
Creator III

Hi,

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

Highlighted
Creator II
Creator II

Uhoh.. better go check this haha...

Highlighted
Anonymous
Not applicable

that's why my question...

Highlighted
Creator II
Creator II

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

Highlighted
Anonymous
Not applicable

does

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

FROM "Org to History";


without QlikView?


Try any other tool for your database.