Icon

parse excel table_​v3

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 29Node 30Node 31 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 External Tool Table Creator 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 29Node 30Node 31 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 External Tool Table Creator

Nodes

Extensions

Links