Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dreweezy
Partner - Creator II
Partner - Creator II

OLE DB connector not showing my the load columns

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. 

Labels (5)
2 Solutions

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

that is odd. 

its possible it is to do with the specific connector.

You will have to manually add the load statement

View solution in original post

dplr-rn
Partner - Master III
Partner - Master III

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";

View solution in original post

15 Replies
dplr-rn
Partner - Master III
Partner - Master III

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";

dreweezy
Partner - Creator II
Partner - Creator II
Author

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.

dplr-rn
Partner - Master III
Partner - Master III

you ned to put the image again. not able to see

dreweezy
Partner - Creator II
Partner - Creator II
Author

dreweezy
Partner - Creator II
Partner - Creator II
Author

LIB CONNECT TO [QLIKENVIRONMENT (XYZ)];

[BUDGET_VW]:
SELECT "FISCAL_YR",
"ACCOUNT",
"AMOUNT"
FROM "QLIKENVIRONMENT"."BUDGET_VW";

dplr-rn
Partner - Master III
Partner - Master III

oh ok.
have you selected the Include load statement checkbox on left bottom (when you select data to load)
dreweezy
Partner - Creator II
Partner - Creator II
Author

i dont see that option available? Do you mind showing me a .png? Thanks.

dplr-rn
Partner - Master III
Partner - Master III

Capture.PNG

dreweezy
Partner - Creator II
Partner - Creator II
Author

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..