User Profile
orenz
New Member
Joined 3 years ago
User Widgets
Contributions
Re: Collecting data from URLs in list
So I think you are very close, I am able to pull the string with the url and it seems to recognize it as a website. however in the new column we added it just says error, how do i point it to the right data transform? When i try and pull data for the first time from the website it looks like this: I can even say that this is the exact transform I want, just done to all the websites in the list let Source = Web.Page(Web.Contents("......removed for privacy..........")), Data1 = Source{1}[Data], #"Changed Type" = Table.TransformColumnTypes(Data1,{{"Column1", type text}, {"Column2", type text}}), #"Transposed Table" = Table.Transpose(#"Changed Type"), #"Promoted Headers" = Table.PromoteHeaders(#"Transposed Table", [PromoteAllScalars=true]), #"Changed Type1" = Table.TransformColumnTypes(#"Promoted Headers",{{"Site Address", type text}, {"Property Owner", type text}, {"Mailing Address", type text}}) in #"Changed Type1" Thank you so much for the help!Collecting data from URLs in list
Hi all, I am trying to download lots lof data from many websites. So in column "A" I have a list of websites (or more accurately a list of different pages on the same site with the same table stuctures) i want to pull data from. I can then use PowerQuery to download and transform the data exactly how I need, but then I want to go to the next website in my list and pull the data and transform it the exact same way. Much like if I was dragging down an equation to repeat it many times with different data. Is there a way I can get PowerQuery to reference a cell relative to where it is and then drag it or copy it hundreds of times? Thank you so much!
