Editing 'Get Data from Web'

[rjbinney]

I am pulling down data from a Wikipedia page that has many tables. I can easily use the "Get Data" function to pull down the tables individually.

But once I pull down, say, "Table 4", it would be great if I could just replicate all of that to do "Table 5," "Table 6," etc. instead of running a new query each time.

It sounds petty even as I'm typing it, so chalk it up to curiousity?

Thanks

 

[Matt Allington]

if the tables have the same structure it can definitely be done. You would have to create one query using a Parameter to specify the table name (eg, Table 1). You can then right click the query and create a function from it. Then you load a list of table names in a new query, add a new column that invokes the function using the table name column as the input to the function. Finally expand the new column.