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 --
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.
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
SELECT "TEST_ID", column2
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)];
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.
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..