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: 
Anonymous
Not applicable

Connection String Appearing with each and every table load

Hello Everyone,

I am connecting QS with Access DB and created a connection and inserted a string.

Now, If I am loading 5 tables then every time connection string is coming again and again...like

Tab1:

Lib to ...Connection String....

Load * from Customer;

Select * from Customer;

Tab2:

Lib to ...Connection String....

Load * from Product;

Select * from Product;

and so on...

Am I missing something? Please suggest

7 Replies
Vasiliy_Beshentsev
Creator III
Creator III

Hi, check out your script code. One connection string for one source of data is enought.

Lib to ...Connection String....

Tab1:

Load * from Customer;

Select * from Customer;

 

Tab2:

Load * from Product;

Select * from Product;

Anonymous
Not applicable
Author

Yeah, I know...But when I insert a new table, Connection String automatically appearing again with every table load.

Why this is happening?

Is this the default behaviour of QS?

Vasiliy_Beshentsev
Creator III
Creator III

Provide screenshot of your code and load window, if you can.

Anonymous
Not applicable
Author

PFA..

Check this

as every time Connection String statement is coming before load statement.

Vasiliy_Beshentsev
Creator III
Creator III

No need to do this every time. Check it.Test.png

Anonymous
Not applicable
Author

I am not doing it...

Every time I load a new table, Connection string comes every time, why it is coming?

Am I clear?

Vasiliy_Beshentsev
Creator III
Creator III

Aahhh, yes. It is Sense paste this string by himself. It is standart operation when you using master wizard of data load.

You can ignore it and leave only 1 row in begin. Try out.