Creating a path for different files

[aitmessaoudali]

Hello community, i have a dashboard that i want to use for different clients. My problem is that i always need to change the names of the qvd files in the script. Is there a way to create a path at the beginning of the script so i could change the name only once? 

This path should lead to a parameters file where i have a prefix of the files' name, that leads to all qvd files that start with the same prefix.

Thanks in advance

Ali

[avkeep01]

Hi,

You can use variables. You can store them in Excel or in a notepad file or you can create a loop.

For example.

LET vClientName = X;

Table1:

LOAD * FROM $(vClientName).qvd (qvd);

[aitmessaoudali]

thanks for replying, but using your script i need to create as many variables as files related to a specific client because i can only load one qvd

[avkeep01 · Accepted solution]

You can use the variable as a part of the qvd name. For example: Path\$(clientname)_sales.qvd (qvd); and for another table: path\$(clientname)_Purchases.qvd.

[aitmessaoudali]

ok thanks, appreciate the help

[aitmessaoudali]

Hey Anton, you know how can i add a path to special sheet in muy excel file?

Thanks in advance