Vlookup using UiPath

[Selvasathya (Sathya)]

Hi All,

I am new to UiPath. I have two Excel sheets, first excel sheets contains list of Names in first column and Email address in second column. The second excel sheet contains date in first column and Names in second column(Names would get repeated). I wanted to first the names together in second excel sheet which I have done it. I am facing an issue in finding the email id from the first excel sheet according to the grouped ones from second sheet. Names in both the sheet will be the same. Kindly help me with this.

[Palaniyappan]

Buddy @Selvasathya

In that case you use join datatable activity in uipath, where you can pass the first datatble and second datatable and make join with names as inner join and get the final output datatable separately.

Buddy this can give you a fine idea about using join table

Merge two datatables with common column

Hi i would like to use merge datatable activity but would like to ask what would happen if both datatables only have one common column, and i would like to merge all columns according to that common column. eg. Table 1 Name Age A 11 B 12 Table 2 Name Address A USA B UK to become Table 3 Name Age Address A 11 USA B 12 UK

Else if you want to use vlookup, we have an option called lookup datatable activity where you can pass the column Name as lookup column in the property and check with first excel datatable, but my kind suggestion is to take the first option, that would work buddy

Hope this would help you buddy

Cheers

[Lahiru.Fernando]

Hi @Selvasathya

You can use the Join data Table activity to join the two datatables here since both has the name as the common field.

So, these are the steps you should follow.

1. Read the two excel sheet data into two separate datatables
2. Use the join Data Table activity with the Inner Join type. For the columns, provide the names of the two name columns so that it can find a match in those two and return only the matching records to you.

there are three different join types which you can use. Refer the link below and you can select what suits you better

Join Data Tables

The output of this activity will be another datatable variable which contains all columns of both datatables. So, if you are to write back to an excel, you can remove unwanted columns using the Remove Data Column activity.

[Selvasathya (Sathya)]

Hi Lahiru,

I am using UiPath 2017.1v due to which I am unable to find join data table activity and unable to install also:(

[Selvasathya (Sathya)]

Hi Palani,

I am using UiPath 2017.1v due to which I am unable to find join data table activity and unable to install also:(

[Palaniyappan]

Which edition you are using buddy community or enterprise

Cheers

[Selvasathya (Sathya)]

It is Enterprise

[Palaniyappan]

@Selvasathya

Buddy a last try kindly try to update the UiPath.System.Activities packge in manage package menu and search for this activity in your activity panel else

Kindly download the new version buddy with this link

Process Automation Software - Request your free download

Cheers.

[Selvasathya (Sathya)]

As per Client requirement I have to use 2017.1v only. I tried to install UiPath.System.Activities but it says “installing this package on 2018.2v or lower causes unexpected changes in workflow”.

[Palaniyappan]

Buddy were you able to see the lookup datatable activity in the panel,
Cheers

[Selvasathya (Sathya)]

were you able to see the lookup datatable activity in the panel,

In Manage Activity panel yes I was able to see it but there was a note “Important: installing this package on 2018.2v or lower causes unexpected changes in workflow”. Due to which I did not try to install.

[Palaniyappan]

Yes you can but other activities will get affected buddy

[sureshj (suresh_hserus)]

@Selvasathya

You can Write cell Activity and write the Vlookup formula in the respective range.
Please find sample working,
Vlookup.xaml (6.3 KB)

Thanks,
Suresh J