This node conveniently converts HTML tables into KNIME tables. It uses some simple heuristics to determine the column names. The result are three KNIME tables. The first KNIME table contains the HTML table’s content, the second and third KNIME tables contain the HTML table’s header and footer.
As KNIME supports no spanning rows or columns, rowspan and colspan attributes in the HTML table are mapped
by simply copying the original cell’s content to the spanning cells.
The HTML table’s header is detected by checking, whether (1) all cells are of type th, or (2) the cells are contained
within a thead element. The HTML table’s footer is detected through the tfoot element.
The KNIME table’s column names are generated from HTML table’s header. In case the header is a single row, the column names equal the HTML table’s header names. In case there is more than one row in the HTML table’s header, the rows are concatenated with “ > ”. In case the HTML table contains no header, the column names are synthetically generated (“column0”, “column1”, …)
Here’s an example HTML table:
| Header A | ||
|---|---|---|
| Header B | Header C | Header D |
| Cell 1 | Cell 2 | Cell 3 |
| Cell 4 | Cell 5 | |
| Cell 6 | Cell 7 | |
This will result in the following KNIME content table:
| Header A > Header B | Header A > Header C | Header A > Header D |
|---|---|---|
| Cell 1 | Cell 2 | Cell 3 |
| Cell 4 | Cell 5 | Cell 5 |
| Cell 4 | Cell 6 | Cell 7 |
And the KNIME header table:
| Header A > Header B | Header A > Header C | Header A > Header D |
|---|---|---|
| Header A | Header A | Header A |
| Header B | Header C | Header D |
The footer table would be empty in this example, because the HTML table contains no footer.
Options
Popular Predecessors
- Start WebDriver11 %
- Table Creator9 %
Extract Outer/InnerHTML9 %- Frame5 %
- Try (Data Ports)4 %
- XPath4 %
File Reader3 %- Group Loop Start3 %
- Synchronize3 %
- Wait3 %
- String to URI2 %
Table Row To Variable Loop Start2 %Recursive Loop Start2 %- HTML Parser2 %
- Column Filter2 %
- Empty Table Switch2 %
- Unzip Files (legacy)1 %
Column Appender1 %- IF Switch1 %
- HTTP Retriever1 %
- Page Source1 %
CSV Reader1 %Generic Loop Start1 %- Nominal Value Row Splitter1 %
- String Manipulation (Variable)1 %
- Rule-based Row Splitter1 %
- Dictionary Tagger1 %
- GET Request1 %
- Download (legacy)< 1 %
- Chunk Loop Start< 1 %
Row Filter (deprecated)< 1 %Excel Reader (XLS)< 1 %Table to HTML String< 1 %- HTTP Result Data Extractor< 1 %
Find Elements< 1 %- Find Elements< 1 %
Execute JavaScript< 1 %- Navigate< 1 %
- Image to Table< 1 %
- Java Snippet< 1 %
Interval Loop Start< 1 %- Column List Loop Start< 1 %
- Extract Table Spec< 1 %
- Empty Table Creator< 1 %
- TimeDelay Loop Start< 1 %
- Table Editor (JavaScript)< 1 %
- JSON to Table< 1 %
- Webpage Retriever< 1 %
- Fail in execution< 1 %
- Web Page Content Extractor< 1 %
- HTML Node to Text< 1 %
Extract Attribute< 1 %Click< 1 %- Current URL< 1 %
- Get Pooled WebDriver< 1 %
- Quit WebDriver< 1 %
- Take Screenshot< 1 %
- Select< 1 %
Views
- This node has no views
Workflows
Links
- Extract Table from website using Find Elementsby armingrudd on 2019-04-28forum.knime.com/p/59584
- Downloading web tableby qqilihq on 2019-12-02forum.knime.com/p/75965
- Directly access data on the webby armingrudd on 2020-04-04forum.knime.com/p/86511
- Finance data retrieval..by qqilihq on 2021-02-13forum.knime.com/p/115781
- Web Scraping datas from a boardby armingrudd on 2020-08-24forum.knime.com/p/100590
- Show all 7 links
Developers
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.