Input data with static file name and dynamic file path.

Question

Hello guys, I am fairly new to analytic app and my goal is to open a specific file on a specific folder. So the user will just run the app and will get the file from the folder.

For Example:

I have CustomersData.xlsx file inside "Data Folder"

and this analytic app is in Transformation folder.

both transformation and data folder are inside a specific folder. so from Transformation folder I think file path will be like ..\Data\CustomersData.xlsx

and I also want to export or output the same way but on another folder called "Output"

DavidP · Answer

Hi @Ultralightbeam

You would typically do this with a file browse tool connected to an input data tool via an action tool. Have a look at the example when you click on the File Browse tool in the Interface Palette.

The File browse tool doesn't allow you to specify the default path though. I don't know if there is an elegant way to do this.