Load Sql Connectionstring from Excel

[bmaheshwari]

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

[Shubham_Deshmukh]

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 ? 

[bmaheshwari]

yes 

If multiple Connection possible then its good other wise how its possible with single Connection string.

[Shubham_Deshmukh]

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.

[Shubham_Deshmukh]

Worked for you?