I’m trying to solve for the most efficient answer. I have two DataTables and am performing a join on two columns. One column is Type is ‘Object’ and its comparing to ‘String’ so all joins are not executed.
I need to convert the ‘Object’ column to ‘String’ so the join is effective. I searched and it looks like I can’t change the type after the DataTable has already been populated? Am I going to have to add a new Column and add each row?
You can create another column with the data type you want and add the converted data to it.
Use add data table column to create a new column. Then use a for each row activity to loop through your datatable. Within the loop, use an assign activity to assign the converted value to the new column.
As you said, you cannot change the data type of the datatable column once its created. Such change will actually lose the data in the column. So the best way that I know of is to have a copy column as explained above with the required data type