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