Lookup Data Table - 2 tables as a source

Help StudioX
1

I have 2 .csv tables as data, both were implemented in UiPath in the form of a data table. The first table is called dt1, the second table dt2. dt1 and dt2 have 5000 rows each.

The columns in the dt1 table that contain data are A,B,C,D and i’ve newly created column E which i want to vlookup the data from dt2.

The dt2 table is to be used as a table in which I will filter data. Using column A from dt1 I want to vlookup column B from dt2. (the data corresponding to A_dt1 in dt2 is A_dt2).

How can I do this? I tried Vlookup but it doesn’t work at all - I want the data to be updated for all 5000 rows and then extract it to .csv final file.

2

@Niedziol,

Welcome to the UiPath community:tada

If you want common data between both datatable, you can use join datatable and join on common data column.

Thanks,
Ashok :slightly_smiling_face:

3

Hi,

i am receiving this type of error trying to join these 2 tables :confused:

image
image1027×136 4.32 KB

4

@Niedziol,

My bad. You should be using Lookup DataTable. Here is sample solution:

image
image711×1333 54.4 KB

Sample Code:
LookupDt.xaml (12.4 KB)

Output:
image

Thanks,
Ashok :slight_smile:

5

Hi @Niedziol, can you show a picture of what you need? Also, can you send a picture of your Join? Regards.