Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik Certification Exam Sale - 40% off. Register by June 30, 2020. GET DETAILS
Highlighted
Partner
Partner

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. 

2 Solutions

Accepted Solutions
Highlighted
Partner
Partner

Re: OLE DB connector not showing my the load columns

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

Highlighted
Partner
Partner

Re: OLE DB connector not showing my the load columns

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
Highlighted
Partner
Partner

Re: OLE DB connector not showing my the load columns

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

Highlighted
Partner
Partner

Re: OLE DB connector not showing my the load columns

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.

Highlighted
Partner
Partner

Re: OLE DB connector not showing my the load columns

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

Highlighted
Partner
Partner

Re: OLE DB connector not showing my the load columns

Highlighted
Partner
Partner

Re: OLE DB connector not showing my the load columns

LIB CONNECT TO [QLIKENVIRONMENT (XYZ)];

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

Highlighted
Partner
Partner

Re: OLE DB connector not showing my the load columns

oh ok.
have you selected the Include load statement checkbox on left bottom (when you select data to load)
Highlighted
Partner
Partner

Re: OLE DB connector not showing my the load columns

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

Highlighted
Partner
Partner

Re: OLE DB connector not showing my the load columns

Capture.PNG

Highlighted
Partner
Partner

Re: OLE DB connector not showing my the load columns

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