I have a list of .txt filenames. How can I import them from the web and combine them, without doing so individually? Thanks.
I have a list of .txt filenames. How can I import them from the web and combine them, without doing so individually? Thanks.
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
3 people are following this question.