I’m guessing this has something to do with attempting to convert path variables to another data type. However a path is generally a string so if that’s the case then this isn’t a well-conceived node. I’ve got two path values, a binary, and a string and I want to convert them all to strings so I can insert them into another table. This cryptic error message isn’t helpful. Is there an alternative because it seems from reading that a lot of folks have run into this error.
Hi @kevinnay , This unfortunately is a bug in the String Manipulation multi Column node which appears whenever it is presented with data types such as Boolean as in your screenshot.
This post may give some ideas on handling it, but unfortunately the multi column node is not as useful at it ought to be because of this limitation.
Also mentioned here.
In terms of your specific problem, is it just the two columns (in which case the regular String Manipulation node, called once for each column would be an option) or is for a dynamic number of columns? (so possibly a column list loop with string manipulation enclosed may be the option, although you will need some additional work for handling “current column”. It’s somewhat frustrating as the multi column string manipulation node ought to be a nice simple solution to this kind of problem.
You can also using a combination of unpivot, string manipulation and Pivot nodes to perform the conversion.
eg
3 Likes
Thanks for the suggestions.
1 Like