Forum Discussion

DataKimble's avatar
DataKimble
Regular Visitor
4 years ago

Adding a column from the source file name – The file is sourced via a URL

Hey all,   I am currently grabbing a CSV file via a public URL: e.g. Source = Csv.Document(Web.Contents("https://fixturedownload.com/” & “download/" & "target_file" & ".csv"),[Delimiter=",", Colum...
Need Help
jbwtp's avatar
jbwtp
Icon for Memorable Member rankMemorable Member
4 years ago

Hi DataKimble,

 

I think that you should be able just to add a column, something like this:

Table.AddColumn(Source, "URL", each "https://fixturedownload.com/" & "download/" & "target_file" & ".csv")

 

Is tihs what you are after?

 

Cheers,

John

DataKimble's avatar
DataKimble
Regular Visitor
4 years ago

Hey John, 

 

Thanks for your reply.  Unfortunatley this is not so much the solution that I am hoping for. 

 

Your suggested approach looks to involve typing the URL in as opposed to referencing the URL used when souring the data.

 

To provide more context, I am actually grabbing a number of files from that URL, all of which have the same URL but finishing with a different file names e.g. :

  1. "https://fixturedownload.com/download/target_file_2022",
  2. "https://fixturedownload.com/download/target_file_2021".

Ideally I would like to source the file name from the URL for each file that I grab. 

 

Thanks!

 

KM

  • jbwtp's avatar
    jbwtp
    Icon for Memorable Member rankMemorable Member
    4 years ago

    Hi DataKimble,

     

    But I guess the URLs + filenames are comming from somewhere? You should be able to grab them from this source. I think this would be easier if you could share a part of your query which deals with getting the files from the URL (including the bits where you set which URL/filenames to be used). From there I will be able to tell you what exactly needs ot be done in your code.

     

    Kind regards,

    John