Comparing row and column

Learning Initatives Automation Starter
1

hello I want to automate excel automation, have input sheet and in the excel there two sheet ,in the first sheet having row name “skills” and second sheet having same name “skills” column .i want to match the “skills” row to the “skills” named column. how can i do that? how we can compare row and column?

2

For non matching records

DataTable1.AsEnumerable().Where(function(row) Not DataTable2.AsEnumerable().Select(function(r) r.Field(Of String)(“skills”)).Any(function(x) x = row.Field(Of String)(“skill”))).CopyToDataTable()

For matching records

DataTable1.AsEnumerable().Where(function(row) DataTable2.AsEnumerable().Select(function(r) r.Field(Of String)(“skills”)).Any(function(x) x = row.Field(Of String)(“skill”))).CopyToDataTable()
3

which activity should i use for matching row and column?

4

you can use assign activity and in that
Left = datatable variable
Right = the expression that I have given

5

Thanks can i get ur mail id any further queries?

6

palsanjit8558@gmail.com, you can ask any query if you have.