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: 
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
Master III
Master III

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!

View solution in original post

7 Replies
Gysbert_Wassenaar

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
maxgro
MVP
MVP

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
Master III
Master III

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
Author

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
Master III
Master III

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
Master III
Master III

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
Author

Hi

yes I received the reply i needed, many thanks

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