topic Re: Soft Coding Folder Paths in QlikView

Soft Coding Folder Paths

Fri, 13 Mar 2015 05:43:27 GMT

Hi All

I would like to know how I can soft code folder paths and files paths which I am using as sources in my QlikView documents. I want to prevent my documents from failing if these paths are changed for any reason.

How can I do this?

Re: Soft Coding Folder Paths

Anonymous — Fri, 13 Mar 2015 06:01:02 GMT

Hi ,

Best practice for coding is maintain standard folder strucutre for your qlikview projects.

and Define the generic variables for qvd,qvw,source,configuration file paths as below. These variables will not consider your source drive(like C:\ or D:\) or any static folder path. These variables identify other folders based on you qvw path.

Set

vMasterQVD = '..\Master QVDs\';
Set vFactQVD = '..\Fact QVDs\';
Set vSourceFiles = '..\Source Files\';

use above variables as prefix to your file names in load statements.

Hope this helps,

BR,

Chinna

Re: Soft Coding Folder Paths

Fri, 13 Mar 2015 06:25:18 GMT

Hi Chinna

Thanks for your reply. How would I write this in your format?

This was written by another developer so I want to make sure it's dynamic.

Load....

FROM (XmlSimple, Table is [DocumentSummary/VariableDescription])

Re: Soft Coding Folder Paths

Anonymous — Fri, 13 Mar 2015 06:40:34 GMT

You may have to replace the above fully qualified path with a vaiable. in the variable you have to define the path based on your source and destination qvws folder paths. if both are always in similar folder structure you just have to consider the folder structure orginated from your qvw path.

Re: Soft Coding Folder Paths

Fri, 13 Mar 2015 06:55:41 GMT

Thanks very much!