Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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?
Solved! Go to 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,
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.
User | Count |
---|---|
84 | |
82 | |
66 | |
52 | |
46 |
User | Count |
---|---|
100 | |
48 | |
42 | |
39 | |
38 |