Combining filtered rows

Hello,

From my main dataset, I filtered out a number of rows based on a certain value in a Column A, I then applied a calculation in a math formula node to these Column A values.
I now want to join these rows seamlessly back with the main dataset, but I can’t seem to get the join set up correct.

Any advice or help is much appreciated.

Hi @rosyanna_098

I think you’re better off with a Row Splitter and Concatenate combination. The filtered rows go to port 0 which you can subsequently apply your math and the the remaining rows go to port 1 untouched. They will be brought together again with the concatenate node.

4 Likes

Thank you! I will give this a go

Thank you @ArjenEX this did the job perfectly.

2 Likes

Good to hear! Please mark the posts that provide an answer to your questions as Solution. That helps the rest of the rest of community finding solutions for similar problems more easily :wink:

2 Likes

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