How can we change data type of column?

Check all columns Datatype
If not String identify the datatype and convert to String

Also how can we fetch currentColumn in Java snippet
I think need to loop through all columns so use Column list start loop
but stating loop does not give me currentColumn

I am trying below:
StringBuilder query = new StringBuilder();
for (int i = 0; i < getColumnCount(); i++) {
String columnName = getColumnName(i);
if (isType(columnName, tInt)) {
String.valueOf(columnName);
}

Hi. I would suggest using the “Number To String” node. This node allows you to select integer or floating point columns to convert to String. If you’d like to always convert all numeric columns, leave the “Exclude list” empty and select the “Enforce exclusion” option (as in configuration dialog below).
I hope this helps.
-Don

.

5 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.