question

VANWIJKANSIE-0636 avatar image
0 Votes"
VANWIJKANSIE-0636 asked Lz-3068 commented

How to apply transformation to a folder of files if one file has already been transformed ?

I have used one excell file to transform data, I now want to apply this to a folder with similar files. How can I use this file that is already set up to transform the data in the rest of the files that are in the folder i want to upload?

power-query-not-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Lz-3068 avatar image
0 Votes"
Lz-3068 answered Lz-3068 commented

@VANWIJKANSIE-0636

  • Convert your existing query as a custom function. It should start with something like:

PIC

  • In a blank query use function Folder.Files to get a table with the files in your folder

  • Add a custom column to invoke your custom function, passing the [Content] field as parameter to the function

You can find an example in Combine All or Selected Excel Sheets or Tables in Folders



demo.png (10.8 KiB)
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @VANWIJKANSIE-0636

Where are you with this? Have you found your way?

0 Votes 0 ·

yes thank you for the help

0 Votes 0 ·
Lz-3068 avatar image Lz-3068 VANWIJKANSIE-0636 ·

@VANWIJKANSIE-0636. Well done!!! Thanks for posting back. Take care...

0 Votes 0 ·