Databases Reference
In-Depth Information
We have now created an include file that sets the
vFolderSourceData
variable to the
path of the source data folder.
In a real QlikView environment, it is advisable to specify paths
in UNC format, for example:
\\myserver\source_data
.
Now all we have to do is replace every instance of the hardcoded file path with the
new variable file path. To do this, follow these steps:
1.
In the
Edit Script
window, select
Edit
|
Find/Replace
from the menu.
2.
In the
Find What
input box enter
..\Data Files\
.
3.
In the
Replace With
input box enter
$(vFolderSourceData)
.
4.
Check the
Search all tabs
checkbox.
5.
Click on the
Replace All
button.
6.
Click on the
Close
button to close the dialog window.
Every hardcoded instance of the source data folder is now changed to the
vFolderSourceData
variable. Now, if we need to change the folder location we
only need to change it in a single place. Of course, the same logic can be applied for
database connection strings.