Icon

Prefix groups of rows with preceding text

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