I have a table from "Lead rolling actors" from Wikipedia and I want to add some columns to the table with the dates of birth, years active etc for every actor.
Sample 2:
In this sample, 1970–present
is retrieved from https://en.wikipedia.org/wiki/Robert_Downey_Jr
.
=IMPORTXML("https://en.wikipedia.org/wiki/Robert_Downey_Jr","//td[@class='infobox-data' and ../th[contains(text(),'active')]]")
Note:
- Although I'm not sure about your current URL of
Robert Downey Jr
, for example, how about checking the URL again? Because when I use the URL ofhttps://en.wikipedia.org/wiki/Robert_Downey_Jr
, your expected values could be retrieved.