Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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);
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
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.
ok thanks, appreciate the help
Hey Anton, you know how can i add a path to special sheet in muy excel file?
Thanks in advance