Unable to join two datatable completely using join datatable.
Resolving Data Population Issue in Join Data Tables Activity Using UiPath
Issue Description: Join Data Tables activity was functioning correctly, but certain data was not populating in the resulting data table.
Root Cause: The root cause was identified as the data being recognized as string values instead of integers, leading to missing information.
Resolution:
- Identification of Data Type Issue: Check the data being retrieved is recognized as String values instead of the required integer format.
- Manual Format: Manually adjusted the format of the column in the main file to "Text".
- Automate Formatting the datatype: To automate the conversion of column format from integer to text using UiPath, the following solution was suggested:
Utilization of Format Cells Activity: Recommended using the Format Cells activity, which is a modern Excel activity in UiPath, to set the desired formatting for the range. Referenced documentation: Format Range - UiPath Activities
Implementation Steps:
- For example to convert the column format to Text, use the Use Excel File activity
- Perform Read Range
- Specify the range in the Format Cells activity
- Execute the process
- Now, the set column range should be formatted to Text
- Post which on using the Join data table activity, the result will be as expected, and all required data will be populated.