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.
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.
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