Icon

parse excel table

loop version (uses outdated modulo-rowindex method -- replace with double Rule Engine and Missing Value to adapt) look ma', no loops! readxlsxqueryparadeiser ParadisspeciestomatogroupsrowIndexjoinLEFTjoinLEFT"previous row"to fill valuesrowindexASCremovenon-tomatoesloop overtomato groupsremovegroup nameremoveempty rowsrowIndexNode 15columnIndexappendtomato grouploop endtomato groupsNode 22removegroup nameremovebad rowscolumnIndexrowIndexfill gapsrowIndexNode 28Node 29 Excel Reader Webpage Retriever XPath XPath Math Formula Joiner Joiner Missing Value Sorter Rule-basedRow Filter Group Loop Start Row Filter Missing Value Math Formula Pivoting Math Formula ConstantValue Column Loop End Column Rename ReferenceRow Filter Rule-basedRow Filter Rule Engine Rule Engine Missing Value Pivoting Column Rename loop version (uses outdated modulo-rowindex method -- replace with double Rule Engine and Missing Value to adapt) look ma', no loops! readxlsxqueryparadeiser ParadisspeciestomatogroupsrowIndexjoinLEFTjoinLEFT"previous row"to fill valuesrowindexASCremovenon-tomatoesloop overtomato groupsremovegroup nameremoveempty rowsrowIndexNode 15columnIndexappendtomato grouploop endtomato groupsNode 22removegroup nameremovebad rowscolumnIndexrowIndexfill gapsrowIndexNode 28Node 29 Excel Reader Webpage Retriever XPath XPath Math Formula Joiner Joiner Missing Value Sorter Rule-basedRow Filter Group Loop Start Row Filter Missing Value Math Formula Pivoting Math Formula ConstantValue Column Loop End Column Rename ReferenceRow Filter Rule-basedRow Filter Rule Engine Rule Engine Missing Value Pivoting Column Rename

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: JohannesHolzschuh
Created at: 2022-02-13
On NodePit since: 2022-02-16
Last update: 2024-04-27
Created with KNIME version: v4.5.1

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!