Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using the OLE DB connector to bring in our data. Problem is, I don't see the normal syntax in the script to do transformations on columns in the script.
I don't see the normal syntax --
[TEST_VW]:
LOAD
[TEST_ID],
SELECT "TEST_ID"
FROM "ORACLE"."TEST_VW";
Instead, I only see everything you would see normally after the load columns. So only the SELECT... then all the columns. I'm not sure how I can even begin transforming data? Is this a connector issue? I've tried manually creating the LOAD columns but qlik will not properly read it in.
I've double checked this against my desktop version and I don't see that option there either.
that is odd.
its possible it is to do with the specific connector.
You will have to manually add the load statement
I am confused as well. I've tried manually uploading the LOAD part but the script doesn't like it and won't let me load the data.. I bit stuck here. May have to route this over to the qlik support.
manually updating should work.
so in your case. Make sure the semicolon and 'sql' is there after your load statement
LIB CONNECT TO [QLIKENVIRONMENT (XYZ)];
[BUDGET_VW]:
load
FISCAL_YR,
ACCOUNT,
AMOUNT
;
sql
SELECT "FISCAL_YR",
"ACCOUNT",
"AMOUNT"
FROM "QLIKENVIRONMENT"."BUDGET_VW";
got it to work after the manual update.. hoping this is a bug and will get fixed on the next update.. if not will probably route this over to qlik's support.