Našimi kurzy prošlo více než 10 000+ účastníků
2 392 ověřených referencí účastníků našich kurzů. Přesvědčte se sami
This short tutorial describes the Power Query (Get and Transform) connection to a file, whose name and path is written in a specific cell. This can be used when you needs to simply control, which file is used as source, without even opening Power Query.
First of all add a table with one column and one row and type filepath to its only cell. The name of table is going to be, lets say, “Path_table” and the name of its only column is going to be “Path_column”.
The query getting data from variable path will be like this:
Or, more practically, we can split it into more queris – getting of value and its use.
Obviously, replace the red texts with your names of table and column.
Analogically, you can use this to define a path to folder.
If you need relative path instead of the absolute one, click here.
Comments are closed.
2 392 ověřených referencí účastníků našich kurzů. Přesvědčte se sami
Pište kdykoliv. Odpovíme do 24h
© exceltown.com / 2006 - 2023 Vyrobilo studio bARTvisions s.r.o.
ftest