Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I want to load sql connection string from excel sheet or any text file. can you please suggest me how i will do in Qliksense
and Also i required sqlserver connection string formate .
Thanks
Let me understand this, there are several connection strings present in excel or text file and you want to get that one right? Means extraction from excel ?
yes
If multiple Connection possible then its good other wise how its possible with single Connection string.
You can include connection string from file using include as shown in vid, also you can get that connection string name using connectionString() script function.
Check out below link,
https://www.youtube.com/watch?v=2aummH1vdao
Let me know this works for you or not.