Icon

Prefix groups of rows with preceding text -v2

Sample DataFind the prefix rowsGather "previous" prefixJoin prefix and texttidy upFind the prefix rowswhich are all the "TITLE:" linesRecord rowindex for eachCreate 5 new rowsfor each "title" rowGenerate anumeric counterto be used tomatch things backlaterin original orderColumn containing "6" which is used by One Row to Manyturn 1 row into 6 rows(i.e. to create 5 new rows)Exclude rows thatdont't contain a "TITLE:"valueGet rowModulo 6(numbers this rowthrough next 5 from 0 to 5)Apply Prefixes to original columnSort intooriginal orderExcludes first of groupwhich is the "title" lineCalcs row numberto match to originalbased on "title" row number plus 1..5tidy upCreate Prefixed TextMissingbecomes empty stringTable Creator Rule Engine Java Snippet String Manipulation Column Filter Rule Engine One Row to Many Counter Generation ConstantValue Column Row Filter Math Formula Joiner Sorter Row Filter Math Formula Column Filter String Manipulation Missing Value Sample DataFind the prefix rowsGather "previous" prefixJoin prefix and texttidy upFind the prefix rowswhich are all the "TITLE:" linesRecord rowindex for eachCreate 5 new rowsfor each "title" rowGenerate anumeric counterto be used tomatch things backlaterin original orderColumn containing "6" which is used by One Row to Manyturn 1 row into 6 rows(i.e. to create 5 new rows)Exclude rows thatdont't contain a "TITLE:"valueGet rowModulo 6(numbers this rowthrough next 5 from 0 to 5)Apply Prefixes to original columnSort intooriginal orderExcludes first of groupwhich is the "title" lineCalcs row numberto match to originalbased on "title" row number plus 1..5tidy upCreate Prefixed TextMissingbecomes empty stringTable Creator Rule Engine Java Snippet String Manipulation Column Filter Rule Engine One Row to Many Counter Generation ConstantValue Column Row Filter Math Formula Joiner Sorter Row Filter Math Formula Column Filter String Manipulation Missing Value

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: @takbb Brian Bates
Created at: 2021-07-08
On NodePit since: 2022-02-06
Last update: 2024-05-02
Created with KNIME version: v4.3.3

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

Try NodePit Runner!