Create one list of values on which you want to filter third column. let us assume list a
(From p in dt1.AsEnumerable()
where Convert.Tostring(p.Item(“ColumnB”)).Equals((From q in dt1.AsEnumerable() Select Convert.ToString(q.Item(“ColumnB”)).ToList(0)) and lista.contains(Convert.Tostring(p.Item(“ColumnB”)))
Read the excel with add headers property checked and save to datatable dt
In Assign activity, save this query to a datatable variable (From row in dt.Select() Where row("ColumnB").ToString.Equals("20180101") and (row("ColumnC").ToString.Equals("3") or row("ColumnC").ToString.Equals("5")) Select row).CopyToDatatable
we have to filter the second column based on the first value , So I took the first element by taking the second column as a list. suppose in the first place instead of ‘20180101’ if some other value is there then we have to take that value.
I think this is the requirement. Sorry if I am wrong.