I’m having an issue with the column combiner node, specifically when I want to specify the order in which the columns should be combined.
I am specifying the columns to combine via flow variable (e.g. [First Name, Last Name] and the node accepts it in the included_names variable without issue, BUT the node appears to combine the columns in the order they appear from the main table, not in the order I am specifying.
For example:
- When I combine [First Name, Last Name], I get the result “Smith”“John” instead of “John”“Smith”.
- If I reverse the order in the list variable (e.g. [Last Name, First Name]), I get the same result (“Smith”“John”).
I can’t use a string manipulation node to join the values because I don’t always know how many columns I am combining (could be 2-5 columns in my case). Thanks!