Hello @smithcreed,
if I got you right you have value text1, text2, text3 in one column and value text3, text4 in another one. Option Unique concatenate output will not be text1, text2, text3, text4 but text1, text2, text3, text3, text4 as values compared are entire cells. You’ll notice difference if you change separator in Column Aggregator node to something different than comma. To get text1, text2, text3, text4 from above two column you need split your columns and then aggregate them.
If I didn’t got it right can you please share reproducible workflow example? See here for more: Reproducible (Minimal) Workflow Example
Br,
Ivan