Downloading web table

Hi (again) Jay,

when working with tables, I definitely suggest to have a look at the Table Extractor node first. In case the website provides a properly formatted <table> element this node will automatically convert it to a KNIME table.

Example from the Wikipedia page List of languages by total number of speakers:

Use the Find Elements node to enter the query for the table. Here I’m using the CSS query .wikitable.

Then simply connect a “Table Extractor” and you’ll get a KNIME table which looks as follows:

The workflow is a simple as:

image

You can find the sample workflow on my NodePit Space:

Feel free to get back in case of questions!

Best,
Philipp

5 Likes