Forum Discussion
Multiple web queries
Hello serhito
you have to load this table into power query, add a new column where you access the data probably with Web.Contents using one or both columns in your table (I can't know what you are really looking for). Depending on what you will get from this data source you can pivot your first column. But I think you will get a table from your data source that however you have to transform, before you are able to get a single value.
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Community ChampionHello serhito
you can add a new column and implement there your data access and using the url-column as parameter for it
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
The ticker list is way longer than displayed and it will change over time.
How do I create a webquery based on the url in column B ? The output of that query would be in the yellow area for its respective ticker symbol.
Please note, I am not an expert at this.
- Jimmy801
Hello serhito
you have to load this table into power query, add a new column where you access the data probably with Web.Contents using one or both columns in your table (I can't know what you are really looking for). Depending on what you will get from this data source you can pivot your first column. But I think you will get a table from your data source that however you have to transform, before you are able to get a single value.
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
JimmyThank you so much !
I figured out how to pull all the data into one table. Working on extracting and sorting the data, but you have helped me figure out the most important part.
