Hi All, I have requirement like below could someone help me on this please,
File 1 is,
File 2 is,
Output should be,
If file has Q or M in position 6 then 1 count should be added and total count should reflect into the second file position 7.
In my example you can see that File 1 was having two records one with Q and another one with M. So, total count of records which was having Q or M is 2. So, File 2 should be updated with 2 instead of 3 in position 7.