I know the title is a mouthful, but let me explain.
I have a pretty big, but functional flow. Now, I want to make it more manageable, but in order to do that, I need to be able to send a variable to the Joiner node to dynamically select what Columns I want from the second source.
Now, I know I can control those columns using the included_names mapping to a variable, but for the life of me, I can’t figure out how to add 2 (or more columns).
I tried using comma space ; / \ | as a delimiter … nothing worked.
Any clues? I found some old topics on the matter where in the old joiner there was a 0,1 etc option, but that’s a deprecated node and I’d like to avoid using it.
The ones that you have there as variable are all of type string. If you look closely in the flow variable tab of the joiner you’ll see that it needs to be of type string list: s[] . In any case the actual flow variable type needs to align with what the node is expecting
There are several ways to create this string list, depending on how you are defining your desired columns. Below is a small test setup:
You’re both right and wrong at the same time
You’re wrong about what I wanted, but absolutely correct about what I needed
I failed to spot the List part, my brain saw S and apparently instructed my eyes to stop reading
Indeed, it needs a list. Now all I have to figure out is how to continue, but now that I know what I need, I’ll figure out the rest.