Rejoin a split table

Hi,

I’m pretty new to KNIME and not a coder at all. I started using it because Excel just couldn’t handle the size of my data, mainly doing Excel-like transformations and some basic automation.

Initially, I used the ‘Missing Values’ node to copy down ID number numbers, which worked. However, a new dataset with invalid data in an ID number field required me to split the data into two tables for cleanup.

Now, I’m having trouble rejoining these tables. The Joiner node won’t allow me to use the original RowIDs (due to potential duplicates, which do not exist as the data was originally a single table). Creating new RowIDs changes the original row order, which is necessary for the ‘Missing Values’ copy down operation.

Is there a means to rejoin these tables while maintaining the original row order? Any suggestions would be greatly appreciated or any advice on how to better do the data cleanse so I am not faced with this issue would be amazing.

Thanks!