Hi @Ashok121,
So the additional complication to your problem is that some files contain no data rows, and so won’t appear in the consolidated table, and thus cannot appear in the output of the Row Aggregator or GroupBy.
I’m assuming you are reading the files in a loop as per your other question at
You could adapt that, and count the rows as you go, so this will then also include the “empty” files.
The additional processing counts the files and generates a row for each xlsx consisting of path and row+header count. This is then output to the additional data port added to the Loop End node, so the lower output will be a table of row counts.
I have made modifications to the original workflow in the error handling branch, and added this additional processing (marked in red) and uploaded to the hub. Here is the updated version which includes row counts.
As this process was also dealing with moving “corrupted” files, these still get included in the counts but an additional column identifies if a failure occurred.