Not getting Excel Data Problem

Help
, , ,
1

Hello everyone.
My apology for asking several times for the same work. :cry:
Let me upload again these example excel files and my activity with RPA. :sweat:
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.

image
image1555×570 206 KB

Please help me with this and thank you. :smiley:

1 Like
2

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.

1 Like
3

Hello @SaurabhDisawal
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 ?

4

@hsupyaewoon

Yes we can remove spaces.

If you want to remove spaces before or after the text then use Trim method to remove it.

                yourExcelCellValue.Trim

If you want to remove spaces in between text then use Replace method to replace space with empty value.

           yourExcelCellValue.Replace(" ","")
1 Like
5

Hi @lakshman
Thank you for your answer.
I have got this error.
Please help me.
Thank you.
image
image

2 Likes
6

@hsupyaewoon

I guess the expression you mentioned in Column Table 1 is wrong. Please check it once.

2 Likes
7

@hsupyaewoon

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.

1 Like
8

@lakshman Thank you for your answer.

Hi @SaurabhDisawal.
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 ?
Thank you.

1 Like
9

@hsupyaewoon
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.

1 Like
10

@SaurabhDisawal
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.

11

@hsupyaewoon

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 :slight_smile:

Capture
Capture1258×656 28 KB

1 Like
13

Hello @SaurabhDisawal
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.
Appreciate it. :smiley:

1 Like
14

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