Power Query parametized

[philaugust2004]

I want to get data from this site

Leeds United football club: record v other sides

Leeds United football club record against all opponents, including all match details.

www.11v11.com

using any team on left side of the page as the opposition so if say I choose Cardiff City the page would be
https://www.11v11.com/teams/leeds-united/tab/opposingTeams/opposition/Cardiff City/

I want to be able to have the Cardiff City part (or any opposition ) to be added via a cell in a worksheet as now i change the power query manually
I have searched the internet but can't find anything that works. but I'm sure it should be easy and it was a lot easier in the days of webquery rather than Get & Tranform!

 

[alansidman]

A bit of a convoluted Answer.
1. Bring your (Cardiff) table into PQ.
2. Click on the Cog Wheel in the source line
3. Remove the Term in the first line "Cardiff City" and in the next line type in TeamParam
4. With your Query open, click on Manage Parameters
5. Fill in the Parameter as shown below. You will need to list all the other teams you wish to include. I have not found an easy way to do this.
6. When you open your query, Click on Team Param and make your selection

 

[philaugust2004]

Thanks. That's a big improvement over what I had.

 

[alansidman]

You are welcome.