VLookup on large data

[ppr (Peter Preuss)]

Have a look on the Lookup Datatable Activity

Give a try on the Join DataTable Activity

with the concept of:

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…

Lets assume: find all MatDocs for Transaction Confirm No we would do:

LeftTable: ECC…, Right Table: Ops, Join Type: Left Join
From Join Result we can identify the matches / non matchtes if right table join col is empty or not

As an Alternate we can create a LookUp Dictictonary or writing a custom LINQ statement