How to merge multiple lines into one.

KNIME Analytics Platform
#1

How to merge multiple lines into one. So that when combined, it starts from the bottom in the same line

IMG_20220328_145631
IMG_20220328_1456311113×1305 157 KB

#2

Hello @Nuke_Attokurov

You can use ‘Cell Splitter’ node with “\n” as delimiter and \ as scape character.

Then you can reorganize the column arrays backwards, in reverse order.

BR

2 Likes
#3

Hi @Nuke_Attokurov
Please find a possible implemented solution with Cell Splitter:

image
image1354×806 263 KB

Displayed tables match with input and output.

20220328_merge_multi-line_reverse_order.knwf (60.3 KB)

The Group Loop option can be considered in cases with different number of multi-line rows, as the Column Aggregator node doesn’t handle the nulls in an efficient way. Removing the Loop will require further String Manipulation


BR

5 Likes
#4

Ooo.
Thank you very much

#5

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.