Change data format from datatable not using excel

[Temuulen_Buyangerel]

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

[ppr (Peter Preuss)]

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

[Temuulen_Buyangerel]

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

[Temuulen_Buyangerel]

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

[ppr (Peter Preuss)]

@Temuulen_Buyangerel

144569

We assume the following:

@Temuulen_Buyangerel

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

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

@Temuulen_Buyangerel

when i write it on new workbook, that cell says The number in this cell is formatted as text or preceded as an apostrophe

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

[Temuulen_Buyangerel]

Thanks for quick advice I will try