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:
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
Thanks for quick advice I will try
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.