Hi All,
I have 2 two datatables.
Table1 -
Column Name
A B C D E
2025-03-14 2354 1345 1312 3521
2025-03-15 2314 1345 1322 3431
2025-03-16 2314 1345 1332 3421
2025-03-17 2354 1345 1312 3421
Table2 -
2025-03-14 2351 1345 1312 3521
2025-03-15 2314 1245 1322 3431
2025-03-16 2314 1345 1132 3421
2025-03-17 2352 1345 1312 3421
I want compare both table and columns.
Compare table 1 and table 2
B and B variance within 1 %, need to validate both table same column values. Any one cell more than 1% i want outout entire column false.
Expected output is
B - True
C - False
D - False
E - False