Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
does the sql select work without QlikView?
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
Hi,
There seems to be a comma missing before "Hot_Warm".
Uhoh.. better go check this haha...
that's why my question...
Believe it or not; that made no difference! How strange
does
SQL SELECT "_OrgID", "Type", "Complete", "CreatedBy", "Note", "ActionDateStart" "Hot_Warm"
FROM "Org to History";
without QlikView?
Try any other tool for your database.