Forum Discussion
Need to extract values from named cells (Get and Transform)
If so your filepath shall be
C:\Users\Jema\Veidekke\NO-ENT-GLENCORE Cu-Bygg - Teamdokumenter\Intern Prosjekt Dokumenter\10 Økonomi\10.04 Endringer\Endringsmeldinger (EM)\EMAttached file works if another 3 folders are under above one.
Hi Sergei,
I'm sure Your suggestion Works, but for unknown reason the editor freezes when I try to open the Query to change the file path.
If I have an empty file, I'm also not able to use the editor.
I uploaded a New files, as the first file did not have any table in it.
The New file has the right file path, colud you please try to insert the correct file path and upload it again then I can test it.
Best regards
Jesper
In attached file I added FilePath table to have filepath as parameter. It extracted within the script as
let
SourcePath = Excel.CurrentWorkbook(),
GetFolderPath = Table.SelectRows(SourcePath, each ([Name] = "FilePath")){0}[Content]{0}[FilePath],
Source = Folder.Files(GetFolderPath),I guess in your case that will be
C:\Users\Jema\Veidekke\NO-ENT-GLENCORE Cu-Bygg - Teamdokumenter\Intern Prosjekt Dokumenter\10 Økonomi\10.04 Endringer\Endringsmeldinger (EM)\EM\EM001 - Tilleggsarbeid med kranfundament(without the slash at the end compare to your test file)
Hi Sergei,
Managed to get the editor up and running on the "fx GetFileFields" and here I saw the error, have Attached a screenshot of the error Message.
Best regards
Jesper
- It seems like the Query does not exclude all files that are not .xlsx files, at least I now also found an error: The external table does not have expected format, details: xxxxxxx.JPG
Best regards
Jesper
Hi again,
As I can find it seems like the Query looks for a folderpath when I insert the correct path, which by the way is a folderpath (a folder with many subfolders containing the workbooks) - but the Query expects a "filepath"! Could this be the problem?If by any chance we get it to work, the result should prefably look like the screenshot shown a few posts above.
Best regards
Jesper- Hi,
I have tried to insert the correct file path in the Filepath cell, but I get an error saying: " The external table has an unexpected format" and I still can't use the editor as it Locks up.
The reult form the file you uploaded is not quite the same as shown in the screenshot I send over earlier, what could be the reason for this?
