XLS cell merger by row or variable

I have raw data, need merge column 2,3,4 by row, not merge together, and row number is not fixed, some time 4rows,some time 7rows, who can help me , thanks

Function test.knwf (19.1 KB)

1 Like

Hi @Caibing,

In this case you need to create a tag for each row, I created an example workflow to demonstrate this:

It is a bit complicated because I used the Model to Cell node to route the XLS formatting port through the recursive loop nodes.



Thanks for your reply, it can help ,but I have another problem , the raw data as below image , my question ,RowID =“Row0_dup_dup_dup_dup” is fixed, but Row is not fixed, some time is Row=11, sometime=13, so how to write express in Rule Engine, the final data should be the last image.

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

Hi @Caibing,

Sorry for the late reply, just saw your answer.
You can check for the row id in the Rule Engine: