Change data format from datatable not using excel

Hello everyone,
How can I use join data tables by Columns, but the column format is different so data tables are unable to be joined.
Regards,
Temuulen

Please share some sample input data samples and expected output sample.

Depending on the case we may can use a LINQ statement and incorporate the format differences harmonization in it

Hey!
DT1:
Column1 Column2 Column3
Rick 18 144569
DT2:
Column1 Column2 Column3
John 19 144569
Just a simple data tables but column3’s data is from the read range activity and when i write it on new workbook, that cell says The number in this cell is formatted as text or preceded as an apostrophe

Joining them by Column3 but I think the format is different so cannot be joined

We assume the following:
grafik

When both data tables are on the same type: Number, then Join DataTable could work

Just inspect both datatables within the immediate panel
Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

looks more like a formatting issue in excel. Maybe cell reformatting can help
grafik

Thanks for quick advice I will try

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