Dropdown values

[KarthikByggari]

1. Read all the drop-down values in to a Data Table. How to get the values please check the below post -

6.RPA Challenge - Retrieve items from a combobox

Retrieve all items from this combobox:

2. Read your excel values into Data table using Read Range Activity.

3. Compare both data tables to get matched and unmatched values. Refer below threads -

Comaparing Datatables (multiple columns)

Instead of looping thru data tables, you can achieve with two LINQ queries. One is for matched rows Another is for unmatched rows The following LINQ queries are in c#. (The syntax in VB.Net is almost same. Just remove the semicolon at the end) var matched = from table1 in dt1.AsEnumerable() join table2 in dt2.AsEnumerable() on table1.Field<String>("User") equals table2.Field<String>("User") where table1.Field<String>("Client") =…

Compare Datatables one specific column with other specific Column and Get Matched and Not Matched Records`

Hello Community Use Below Code to Compare 2 Datatable Column and Get Matched and Not Matched Records Note- Based on your datatable column datatype update datatype here with column field. To Get Matched Records Datatable Out_Matched_Data = In_DataTable1.AsEnumerable().Where(function(row) In_DataTable2.AsEnumerable().Select(function(r) r.Field(Of Int32)(In_DT2_ColName_To_Match.ToString)).Any(function(x) x = row.Field(Of Int32)(In_DT1_ColName_To_Match.ToString))).CopyToDataTable() To Get Not…

Regards,
Karthik Byggari