We have got requirement to compare 2 datasets and generate reports for the mismatches/ detail records and counts.
And also we are trying to keep it generic for any file metadata.(to enable rcp later)
1. After passing thr diff stage, the below layout is achieved
Code: Select all
Custid, File1name, File2Name, Matchflg, File1address, File2Address, matchflg_addr
1, a, aa, n, x, x, y
2, b, b, y, x, x, y
Custid, file1value, file2value, match
1, a, aa, n
1, x, x, y
2, b, b, y
2, x x, y
How to add the columnnames to above layout, so we can filter n records and group by column name to get the counts.
ie..
Custid, columnname, file1value, file2value, match
1, name, a, aa, n
1, address, x, x, y
2, name, b, b, y
2, address, x, x, y
The file has got 50+ columns.
Instead of pivot, are there any dynamic arrays that can be build and read the values form arrays ? Thanks