Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

Question


Dears,
i am really new and not so technical.
I am trying to create a ODBC connection from my ERP database
I go in Edit scrip and I followed the web suggestion on ODBC connection
I obtained this attached script (see end of the message)
I have an error when I try to load the data:
Unknown statement
ODBC CONNE
SQL SELECT "alfa_alsis_scope",
    artbeskr,
    artikelvariant,
    extordtyp,
    ordantal,
    orddatum,
    saljare,
    varugruppkod,
    "vb_pris"
FROM ArtecAirSU.dbo.orp
I suppose it depnd from alfa_alsis_scope and "vb_pris"
Please, How to solve it? Many thanks

ODBC CONNE
//-------- Start Multiple Select Statements ------
SQL SELECT "alfa_alsis_scope",
     artbeskr,
     artikelvariant,
     extordtyp,
     ordantal,
     orddatum,
     saljare,
     varugruppkod,
    
"vb_pris"
FROM ArtecAirSU.dbo.orp;


SQL SELECT kundbestdat,
     kundref2,
     ordstat,
     slutkundnamn1
FROM ArtecAirSU.dbo.oh;

SQL SELECT ftgnamn
FROM ArtecAirSU.dbo.fr;
//-------- End Multiple Select Statements ------


CT TO AirArtecSu (XUserId is GLBPNZVMQbbEHaZL);
1 Solution

Accepted Solutions
oknotsen
Honored Contributor III

Re: Question

Did you remove most of the connection string part on purpose?

If not, that is your problem.

If you did, please post the exact error you are getting.

May you live in interesting times!
7 Replies

Re: Question

ODBC CONNE is not a valid qlikview statement. Open the script editor, select the option ODBC in the dropdown list at the bottom left and press the Connect button next to it. Then choose the odbc data source you need to connect to your database and supply a user name and password. Perhaps the screenshots in this blog post help: The Great ODBC Confusion


talk is cheap, supply exceeds demand
MVP
MVP

Re: Question

it seems that the last part of the connect statement is at the end of your script

ODBC CONNE

.........................

CT TO AirArtecSu (XUserId is GLBPNZVMQbbEHaZL);


it should be

ODBC CONNECT TO AirArtecSu (XUserId is GLBPNZVMQbbEHaZL);

SQL SELECT ......;


SQL SELECT.....;


there is no need to repeat the odbc connect if the database is the same;

only add another connect if you change the database


oknotsen
Honored Contributor III

Re: Question

Did you remove most of the connection string part on purpose?

If not, that is your problem.

If you did, please post the exact error you are getting.

May you live in interesting times!
Not applicable

Re: Question

Hi , many thanks for your emial.

*I arranged the database extraction, now I am trying to join table from

same source and also from other source.*

On Mon, Mar 2, 2015 at 10:10 PM, Onno van Knotsenburg <

oknotsen
Honored Contributor III

Re: Question

Make sure the fields you want to join on have exactly the same name and figure out what join you want (outer, inner, left, right).

Example of join:

left join(tableToJoinWith)

Load ...

May you live in interesting times!
oknotsen
Honored Contributor III

Re: Question

If your question is answers, please flag correct and helpful reply. Thank you!

Good luck data modeling!

If not, please clarify what answer you are still looking for.

May you live in interesting times!
Not applicable

Re: Question

Hi

yes I received the reply i needed, many thanks

On Wed, Mar 4, 2015 at 3:00 PM, Onno van Knotsenburg <

Community Browser