SQL Load ODBC Tables

[craig157]

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

[Anonymous]

does the sql select work without QlikView?

[Anil_Babu_Samineni]

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

[kamielrajaram]

Hi,

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

[craig157]

Uhoh.. better go check this haha...

[Anonymous]

that's why my question...

[craig157]

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

[Anonymous]

does

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

FROM "Org to History";

without QlikView?

Try any other tool for your database.