Using data source file with changing name

[Anonymous]

We use a database at my workplace were everytime you a file is edited and updated to a new version the version number is included in the file name. So if a file is called "SalesPrice 2.5" it will after the update be called "SalesPrice 2.6". So it is only the last part of the name that changes 

Is there anyway to to use a path to the file in a way so that the path doesn't die when the name is changed?

[Anonymous · Accepted solution]

@Anonymous,

I would suggest you use Folder as your source instead of file because you have to provide an absolute path to it. Using Folder as source, you can filter your Name column to include anything that starts with SalesPrice, click on Binary under Content column, then Table under Data column, and perform any other transformation needed. 

[Anonymous]

@Anonymous 

Much appreciated this worked fine.