topic Re: Question in Qlik Learning Discussions

Question

Fri, 27 Feb 2015 16:16:31 GMT

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

Re: Question

Gysbert_Wassenaar — Fri, 27 Feb 2015 17:48:05 GMT

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

Re: Question

maxgro — Fri, 27 Feb 2015 18:15:10 GMT

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

Re: Question

oknotsen — Mon, 02 Mar 2015 21:10:08 GMT

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.

Re: Question

Mon, 02 Mar 2015 21:12:34 GMT

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 <

Re: Question

oknotsen — Mon, 02 Mar 2015 21:17:06 GMT

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

Re: Question

oknotsen — Wed, 04 Mar 2015 14:00:24 GMT

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.

Re: Question

Wed, 04 Mar 2015 17:07:46 GMT

yes I received the reply i needed, many thanks

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