I have 2 validated excel files which having some columns are matching i need matching column and along some unmatched required columns into single excel file?

Help Studio
, ,
1

i have 2 validated excel files which having some columns are matching i need matching column and along some unmatched required columns into single excel file

how to do this using filter data

2

@Naveen_Kanike

This may help you:
commonColumns = dt1.Columns.Cast(Of DataColumn)().Select(Function(c) c.ColumnName).Intersect(dt2.Columns.Cast(Of DataColumn)().Select(Function(c) c.ColumnName)).ToList()