Forum Discussion
Solved
Need to extract values from named cells (Get and Transform)
Hi, I have made an Get and Transform Query on a folder with many subfolders all containing an workbook with the first sheet named "Endringsmelding" in each. These sheets contains 3 named cells: K5="...
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,
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
Best regards
Jesper
Hi Sergei,
I have tried to remove the last backslash, first attempt was running without this backslash - but still get the error with the "filepath" and not "folderpath" as it need to be. It is a real pain in the rear that I can't make modification to the M code as the editor does not work...
Best regards
Jesper
If so take upper folder
C:\Users\Jema\Veidekke\NO-ENT-GLENCORE Cu-Bygg - Teamdokumenter\Intern Prosjekt Dokumenter\10 Økonomi\10.04 Endringer\Endringsmeldinger (EM)\EMor even more upper