Forum Discussion
Using data source file with changing name
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,
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.
2 Replies
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.