Completeness check between files

Question

Dear Community,

I am seeking one help or suggestion, I have 10 .xlsx files with only single sheets and they all having a similar format and the job was to collate them all into single report, i am done with this activity by with the help of Directory tools and two Batch Macros one for getting sheet names and another Batch Macro which is collating them into single report.

Now for completeness check i need to check the individual file records counts with corresponding file data count in the collated data report, one way is to import all the 10 reports individually using the Input tool and compare each one with collated data report (filtering respecting report data from collated data report).

This process of importing 10 files individually is little big one, i am asking if there is any other way of performing this same completeness check activity? Thanks.

binu_acs · Answer

@Rajat_Rehria add a count record tool and append to the input file in the bath macro which will return the record count

File_Count.yxzp

OTrieger · Answer

@Rajat_Rehria 
 a Summarize tool, in the Batch macro to count entries appending the result to the data.
Whatever you thought to do for each of the files, you can do in the batch macro.