In our current example documents, we have always referred to the Data Files folder for our source data. If, for any reason, this folder has to be moved somewhere else, we will have to manually change the source data path in many locations in many files.
Let's follow these steps to create an included script file to set the source data folder in a single location:
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: myserversource_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:
Every hardcoded instance of the source data folder is now changed to the vFolder Source Data 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.
Qlik View Related Interview Questions
|Microstrategy Interview Questions||IBM Cognos Interview Questions|
|PL/SQL Interview Questions||MSBI Interview Questions|
|VBA For Excel Interview Questions||SAP BO Interview Questions|
|SQL Database Interview Questions||Qlik View Interview Questions|
|R Programming language Interview Questions||Pentaho Interview Questions|
|Advanced SAS Interview Questions|
Qlik View Tutorial
Seeing Is Believing
Data Modeling Best Practices
Basic Data Transformation
Set Analysis And Point In Time Reporting
Advanced Data Transformation
More On Visual Design And User Experience
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.