Hello everyone.
I hoped someone could help me get this right, so i’m trying to go trough som excel sheets and match it too one, now as you can see in my sequense, i’m going to take all my matched data an put it into one DT. So i efterwards can put it into my form.
i tried add data row, merge DT but i can seem to get the correct data out.
Hope someone can help me, thanks 
kontrol differencer.xaml (21.2 KB)
What exactly are you trying to do?
Could you provide a sample of the headers and content for dt_databanktest and dt_samletUdgifter? It doesn’t need to be real data; dummy data is fine.
Are you trying to add rows to the data, or are you trying to find matching rows? I need more specific details to understand.
Hey @Christina_Ilkjaer_Peterse so if i’m not wrong you are try two match two datatables
if yes you can use join Linq query to get the matches data.
(
From a In dt_2
Join b In dt_3
On a(“Sno”).tostring Equals b(“Sno”).tostring
Select dt_Output.Rows.Add ({a(“Sno”),a(“City”),b(“ZipCode”)})
).copytodatatable
so you can customise your column name as per nees dt2 dt3 and dt_output is a datatable variable . to write match data into excel pass the dtoutput var dt1 and dt2 holds the data of excel1 and excel2 .
cheers Happy Automation