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.
this can give you a fine idea about using join table
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
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.
Read the two excel sheet data into two separate datatables
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
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.
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.