question

rootsmusic avatar image
0 Votes"
rootsmusic asked Ehren edited

connect to list of .txt files that are stored on the web

I have a list of .txt filenames. How can I import them from the web and combine them, without doing so individually? Thanks.

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

Ehren avatar image
0 Votes"
Ehren answered Ehren edited

You can do this via a custom function. There are various examples of how to do this online, such as this one. What I would do:

  • Create a parameter and set it to the URL of one of the sample files

  • Create a new web query, and when prompted set the URL to the parameter you created in the previous step

  • Do whatever processing you plan to do for all the files against this sample file

  • Right-click on this sample query and generate a function from it

  • Import the table of file URLs

  • Click Add Column -> Invoke Custom Function. Choose the function you created above, and pass it the column that contains the file URL

  • Expand the resulting column












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.