Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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.
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 <
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 ...
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.
Hi
yes I received the reply i needed, many thanks
On Wed, Mar 4, 2015 at 3:00 PM, Onno van Knotsenburg <