My apology for asking several times for the same work.
Let me upload again these example excel files and my activity with RPA.
I also upload the result of this activity and can someone please help me with this?
new.xaml (12.6 KB) Trial4.xlsx (9.1 KB) Trial7.xlsx (14.4 KB) approver table.xlsx (11.1 KB) ConfigFile2.xlsx (9.2 KB) holiday taken.xlsx (11.1 KB)
I was trying to join two data tables and it didn’t come out.
Here is the result.
Please help me with this and thank you.
Approved Person code (Approve excel) is not exactly matching to the employee number (holiday excel).
I think there are spaces at last.
Just copy the Approved Person code from excel to holiday excel, It will work.
Thank you for your answer and I will fix it.
If you don’t mind, I would like to ask further questions that even if there are some spaces in Numbers, is it possible to ignore those spaces in UIPATH and join correctly two tables like right now ?
Yes we can remove spaces.
If you want to remove spaces before or after the text then use Trim method to remove it.
If you want to remove spaces in between text then use Replace method to replace space with empty value.
Thank you for your answer.
I have got this error.
Please help me.
I guess the expression you mentioned in Column Table 1 is wrong. Please check it once.
You cannot use Trim in Join datatable activity.
If you have to trim the values first trim it using a for each loop and then Join, it will be an overhead.
I would suggest if possible get the correct/clean input data.
@lakshman Thank you for your answer.
Thank you for your answer and also for your suggestion, I will take care of it.
If so, the Trim can’t be used in Join Datatable Activity.
For now, I should trim the data first and output it as a new data ? (by creating new excel file?)
And then join them again ?
yes you have to trim the data first, output will be new data table (no need of new excel), and then join both data tables.
Thank you for your answer.
My apology for not getting the point.
I thought if I use for each activity, then I have to put write range activity(new Excel) in body and then I will use the data of it to join the datatables.
And isn’t this what you mean?
Please teach me and Thank you.
Do like this, make a clone of datatable you want to trim, iterate the DT using for each trim the data and add it to the new DT, use new DT in the join.
Check this image, hope you will get it
Thank you so much for your answer.
I just got it.
I have learnt new thing today because of you.
Really thank you for teaching me and answering my questions.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.