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 aft...
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,
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
Much appreciated this worked fine.