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.
that is odd.
its possible it is to do with the specific connector.
You will have to manually add the load statement
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";
not clear what your problem is. please elaborate.
typically a load statement from db will be like below
[TEST_VW]:
LOAD
[TEST_ID],
column2
;
sql
SELECT "TEST_ID", column2
FROM "ORACLE"."TEST_VW";
I'm hoping this image can explain a bit better. I don't see the usual columns under the LOAD syntax. This is where I would usually be doing my transformation. When I try to manually add them under the LOAD column, it errors out. Any idea why it misses that whole section? Thanks.
EDIT - cannot upload an image right now..
-----------------------------------------------
LIB CONNECT TO [QLIKENVIRONMENT (XYZ)];
[BUDGET_VW]:
SELECT "FISCAL_YR",
"ACCOUNT",
"AMOUNT"
FROM "QLIKENVIRONMENT"."BUDGET_VW";
You can see I'm missing LOAD section with my 3 columns - fiscal_yr, account, and amount columns. It goes straight to the bottom portion which has the double quotes around the fields.
you ned to put the image again. not able to see
LIB CONNECT TO [QLIKENVIRONMENT (XYZ)];
[BUDGET_VW]:
SELECT "FISCAL_YR",
"ACCOUNT",
"AMOUNT"
FROM "QLIKENVIRONMENT"."BUDGET_VW";
i dont see that option available? Do you mind showing me a .png? Thanks.
I dont see that option for me.. I also realized when I go into a stream and look at other developers apps, it does not work/open and says "no data", when in fact there is data and the apps should be displaying. I am also a root admin. I'm beginning to think this issue and not being able to open other developers apps is related..