Hello, 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 searche…

Hi @bradsterling 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 t…

Join DataTable With Different Data Type

Help

bradsterling (brad sterling) July 23, 2019, 4:05pm 2

I found this post using the select statement but can’t seem to get it to work.

1 Like

Topic		Replies	Views
Copy one datatable having Columns of different dataType to other and change the column Datatype Studio studio , question , activities_panel	2	159	November 5, 2023
Convert datatype of data table values Activities studio , other	5	631	May 17, 2023
Join 2 tables with different columns Studio datatable , studio , question	8	299	July 8, 2023
Comparing excel using Join DataTable Activity , data Type issues Help robot , studio	3	799	June 7, 2019
Changing data table column from datetime to string Help	3	3742	December 14, 2018

Most Active Users - Yesterday
ashokkarale
anjani_priya
Dheerendra_vishwakarma
Parvathy
Aakash_Singh_Rawat
Luis_Fernando
bjorn2390
neco
pere
Shiva_Nikhil
More details...

Join DataTable With Different Data Type

Related Topics