Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hello shivesh,
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.
Ex:-
QvdMaker1.qvw
QvdMaker2.qvw
//QvdMaker1.qvw
//Connection String1
CUSTOM CONNECT TO
....................;
Tables load strings............
//QvdMaker2.qvw
//Connection String2
CUSTOM CONNECT TO
....................;
Tables load strings............
yep,,this is a way..but i am asking for understanding..if u cud help plz
Thanks
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.
Ex:-
1. Write the connection string in any text file and then include it with option available in the load script.
$(Include=d:\connstr.txt);
Please find the below link:
SQL connection variables dynamic
connection string | Qlik Community
Hope this help!