Hi @RoyBatty296 , here’s a different approach where I process them vertically with concatenation instead of horizontally with join. I then do a groupby RowID and choose the maximum value for each of the other columns.
It does not need any loop to process any number of columns.
And to expand your use case, I created a third dataframe and added new columns to the first dataframe
Workflow looks like this:
Dataframes:
One (added 2 more columns):
Two (same as yours):
Three (new one):
Results:
Here’s the workflow: Merge columns of two dataframes with same name.knwf (12.7 KB)
EDIT:
Note: The reason why I chose to use Concatenation is because of the fact that the columns are the same name - that’s the basic rule of the project and that’s how the columns are identified.