Icon

kn_​forum_​39997_​parsing_​hierarchical_​data

extract hierachical data in special format

extract hierachical data in special format

extract hierachical data in special format to_share.xlsxlevel$type$ = "G" AND $level1$ = "G" =>"level1"MISSING $type$ AND MISSING $level1$ AND $level2$ = "G" =>"level2"$level$ = "level2" => TRUETRUE => FALSENOT MISSING $level$ => TRUETRUE => FALSEfille previous vealuesNode 6sort byID and versionCounterto keep theorder ofRowsnew_idNOT MISSING $level$ => $id$entity_idNode 14Node 15MISSING $datatype$ => FALSETRUE => TRUENode 19attr_idLevel 2sort by original Counterattr_idfor 2nd LevelNode 24attr_id2nd Counter to make sure thenewest versio is usednew_counter Excel Reader Rule Engine Rule-basedRow Splitter Rule-basedRow Filter Missing Value DuplicateRow Filter Sorter Counter Generation String Manipulation ReferenceRow Filter Rule Engine Column Filter Missing Value Rule-basedRow Filter Concatenate Column Rename Column Filter Sorter Missing Value Column Resorter Rule Engine Counter Generation Column Rename Column Filter extract hierachical data in special format to_share.xlsxlevel$type$ = "G" AND $level1$ = "G" =>"level1"MISSING $type$ AND MISSING $level1$ AND $level2$ = "G" =>"level2"$level$ = "level2" => TRUETRUE => FALSENOT MISSING $level$ => TRUETRUE => FALSEfille previous vealuesNode 6sort byID and versionCounterto keep theorder ofRowsnew_idNOT MISSING $level$ => $id$entity_idNode 14Node 15MISSING $datatype$ => FALSETRUE => TRUENode 19attr_idLevel 2sort by original Counterattr_idfor 2nd LevelNode 24attr_id2nd Counter to make sure thenewest versio is usednew_counterExcel Reader Rule Engine Rule-basedRow Splitter Rule-basedRow Filter Missing Value DuplicateRow Filter Sorter Counter Generation String Manipulation ReferenceRow Filter Rule Engine Column Filter Missing Value Rule-basedRow Filter Concatenate Column Rename Column Filter Sorter Missing Value Column Resorter Rule Engine Counter Generation Column Rename Column Filter

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: m_lauber
Created at: 2022-02-19
On NodePit since: 2022-02-20
Last update: 2024-04-28
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!