Data Tables need to match_Dynamically

Hello Community,

The below-mentioned task needs to perform in the library(reusable component). can anyone suggest to me how to create the flow for the below process?

Hello Community,

can anyone guide me through the flow?

Hello @chaitanyaKumar

Explore the Join Data Table Activity.

Hi @chaitanyaKumar , This can be achieved through LINQ.
Is both dt have same schema?

yes both data tables have same schema

refer below code.

Dim dt1 As DataTable = New DataTable(“table1”)
dt1.Columns.Add(“id”, GetType(String))
dt1.Columns.Add(“value”, GetType(String))

dt1.Rows.Add({“1”,“a”})
dt1.Rows.Add({“2”,“b”})
dt1.Rows.Add({“3”,“c”})
dt1.Rows.Add({“4”,“d”})
dt1.Rows.Add({“5”,“e”})

Dim dt2 As DataTable = New DataTable(“table2”)
dt2.Columns.Add(“id”, GetType(String))
dt2.Columns.Add(“value”, GetType(String))
dt2.Rows.Add({“1”,“a”})
dt2.Rows.Add({“2”,“B”})
dt2.Rows.Add({“3”,“c”})
dt2.Rows.Add({“4”,“D”})
dt2.Rows.Add({“5”,“e”})

'dt1 Except dt2 =>
dt1.AsEnumerable().Except(dt2.AsEnumerable(), System.Data.DataRowComparer.Default)
'dt2 Except dt1 =>
dt2.AsEnumerable().Intersect(dt1.AsEnumerable(), System.Data.DataRowComparer.Default)
'dt1 Intersect dt2 =>
dt1.AsEnumerable().Intersect(dt2.AsEnumerable(), System.Data.DataRowComparer.Default)

i didnt get your code. can you please elaborate.

Hi @chaitanyaKumar , This is already solved in Community, please check below link

Hello you can use flitter data table two matching both datatable values so it will return match or unmatch datatables

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.