Good afternoon, I have been getting instances where if the second table has missing values on a concat node, then it will fill those missing values with the first or third table. Concat Issue.xlsx (8.8 KB) The first row what shows after the concat, and the second row is the same rail car number that shows an ETA. Is there a better way to union in Knime or should I fill all missing values with something so this doesn’t happen?

Concatenate filling in missing values with other tables

Thyme April 16, 2022, 11:33am 2

Can you share a workflow that reproduces this behaviour? We can then see how your input data looks like, what the results are, and what you’d expect. This post might help you:

2 Likes