HI
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)
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.
best,
Gabriel
3 Likes
HI,@gab1one,
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:
best,
Gabriel