I have one global file with a lot of lines containing inputs to be processed by a team. Every line is & correction.
To check the processing I receive many project files (1 by project) that should contain a line with the input correction.
So I expect the individual project files to contain the input corrected line in the global file, among many other lines.
I would like to see if the line in the global file exists in the project file with following fields from the global file being identical: TS PERIOD / FMNO / PROJECT / HOURS /PER DIEM
with the following fields from the individual project files:
Project number/Fmno/Hours/WIP per diem/Time-sheet period
More specifically, I want to see the lines that exist in global file but do not appear with the fields above with identical values. This basically means it was not processed correctly.
On top of this, when TS PERIOD, FMNO, PROJECT and PER DIEM are the same in the global file, I would expect the sum of hours to be found back in the individual project file. If hours are 10 and -5 in the global file I would expect hours 5 in the project file. To see that this was not processed correctly, I would need to see that the line in the project file containing 5 not exists so that i know it has not been processe correctly.
I gave it a try but sth went wrong along the way.
Basically I put everything together in 1 file and then added columns with filenames if the values are the same.
Not the best way probably, but if it would work...
Happy to hear any suggestions.
example input files attached (1 global file and 2 project files)
