How to find matching values in two different data table?

[makboga]

Hi,
I have 2 data tables DataBase

and PersonelDT

I need to take Registration Number from DataBase and find in PersonelDT and write the corresponding Activity Type to DataBase.
For example for 98765 in DataBase I need to get 1215 and write it to DataBase.

I used look up data table activity but it didn’t work.

Thanks.

[vishnuvarthanp (vishnuvarthan)]

Hi,

Can you try using join data table activity in UiPath? you can easily the expected result through this

Story line of Join Data Table

Dear innovator’s, All we know that there is a Join Data table activity in UiPath.If we get any matching scenarios with unique value will approach join data table activity instead of filter/loop/array matching activity to find an exact match. Join Data Table: [image] Combines rows from two tables by using values common to each other, according to a Join rule, which is specified in the Join Type property. Sample Table: [image] INNER Join: The INNER JOIN keyword selects records that have m…

[Gokul001 (Gokul Balaji)]

Hi @makboga

Try with this expression

DT_Final = DT_2.AsEnumerable.Where(Function(r) DT_1.AsEnumerable.Any(Function(r2) r2("Registration Number").ToString=r("Regist. No").ToString)).CopyToDataTable.DefaultView.ToTable(False,{"Registration Number","Amount","Activity Type"})

Regards
Gokul