Need some guidance here.
I need to compare two datatables to find out what columns are matching.
But the challenge is the column names are not the same in both dataTables but the values in the are the ones that I have to compare.
inner join will give you common elements, if you need to check if the data tables are identical. Do a inner join, if the result is blank that means there are two distinct and if they return some rows that means those rows are common.
again, share the file if possible and also mention what comparison you want to perform.
Remember the Filter Datatables deals with Column and Values which I don’t want now.
And also recall the matching columns have different names but same values so I want to keep the same values with different headers of my choice hope it makes sense there