Hello.
I am trying to change the type of all columns to string regardless of the column type.
So, I used string() using the String Manipulation (Multi Column) node, but the following error occurs.
What should I do to resolve this error?
Additionally, if you know how to change all columns to string type regardless of column type, please let me know.
Thanks.
Hi @mychoi
For me it is difficult to say what causes the error, without knowing the input data. So uploading a (sample) dataset (flow) would help.
But another way to convert all your columns to strings is to use the Table Manipulator node.
gr. Hans
Hi @mychoi , unfortunately it’s a long standing bug in String Manipulation (Multi Column) that makes it unsuitable for this task which is a pity because ideally it would be exactly the node to use! If that bug were ever fixed this node would be so much more useful.
For further background see this post
If you have a large number of columns and/or you want to convert a dynamic set of columns, you can achieve this with the following pattern:
Most of the nodes there require zero configuration, with the exception of Add Empty Rows which you should configure to add an additional 1 row, and set the value for String to something other than missing (e.g. XXX), and the final Row Filter which you should configure to remove row 1
I have uploaded a component to the hub that does this, but also allows you to specify the columns to be converted. It will only attempt to convert “character based” data types such as date, xml, json, numbers, boolean.
Hopefully it covers all your data types. Should you give it a try, let me know if it works for you, or if you have any problems with it.
Hello @mychoi
Alternatively, for Boolean and numeric column data types, you can test with ‘Number to String’ node:
Regards
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
