Discussion board where members can get started with QlikView.
Suppose i have 2 data sources.
In 1 data source, i have 5 tables and in other i have 3 tables.
I wrote 1 connection string and took 3 tables from first source. Then wrote 2nd connection string and took 3 tables.
Now i need remaining 2 tables from first data source.
Do i need to write first connection string again?
No need to write first connection string again on same extractor or application.
Hope this help!
I suggest use the QVD Maker for this for first Connection String use other QVD makers and for second another QVD makers.
CUSTOM CONNECT TO
Tables load strings............
yep,,this is a way..but i am asking for understanding..if u cud help plz
If you are using the way right now is also fine it works for you no need to write the connection string again and again you can use Include option here as well as.
Means write your connection string on any text file and just include the connection string txt file into your qvw file.
1. Write the connection string in any text file and then include it with option available in the load script.
Please find the below link:
SQL connection variables dynamic
connection string | Qlik Community