I am unable to pass a Date&Time variable through the String Manipulation Multi Column node. Even when I exclude the Date&Time columns from processing, I get the error:
Execute failed: Invalid type identifier for variable in line 1: n
An old thread on this topic was closed here: String Manipulation (Multi Column): Does not handle date&time columns as $$CURRENTCOLUMN$$
Hi @AndrewDevlin -
I looked up the ticket mentioned in the previous thread. Unfortunately there is nothing new to report - the node still doesn’t support datetime, collections, and other variable types.
I have added a +1 from you on the ticket. Sorry for the trouble.
Thanks for the quick reply.
I was able to get around the error by adding one String column to the exclude with the Date&Time column. See attached.
Ah, thanks for the clarification, I misunderstood your original problem. Glad you found a workaround.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.