Excel export path with parameter

1

Hi,

I have a parameter that is used to "select" the SQL db name I want to use, I would like to have the same name used to the Excel Export file name, but on a specific folder, not the project's folder.

For instance, {dbName} is set to "filename"
It opens the SQL dbname "filename".

I would like to parameter the location of the Excel export
Save the file for instance: C:\temp{filename}

Thanks.

2

Hi Yves,

In this case, use a calculated parameter to calculate the file path. Then use the parameter in action settings instead of a hardcoded file path. For instance:

Define a calculated parameter in the Parameter Editor:

image
image684×258 10.5 KB

Use the parameter in the action settings:

image
image355×521 11.8 KB

3

Thanks Dmitry, it worked perfectly.

Except I've used compinepath() !

combinepath("C:\temp" , {dbName} )

1 Like
4

Using combinepath() is even better! :slight_smile: