Count number of rows for all files in folder

[joannasokolowska]

Hey,

I need to build a solution to check when every report was generated in a folder and how many rows are in each. 

There are many different reports in the folder generated on a regular basis . I am able to use Directory tool to see in one go when they were generated but I am not sure how to check number of rows in the similar way.

Thank you in advance,

Asia

[binuacs · Accepted solution]

@joannasokolowska one of the option I'm thinking is use the batch macro given below and use Count records tool to count the row number from each report 

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/t...

[Qiu]

@joannasokolowska 

I think using the Directory Tool is a good choice.

But first of all, what is the format of these reports, as Excel?

If you could provide a few sample files, we will be happy to assist. 😁

[joannasokolowska]

Hey! I created a batch macro for that and it works! thanks! 

[joannasokolowska]

 I have only CSV files  and directory tool is not enough since there is no information about number of rows. I created a batch macro and it works :) 

[atcodedog05]

Amazing solution @binuacs 🙂 the idea of coupling the batch macro and row count tool together.

Exciting to hear you were able to solve it for csv file also @joannasokolowska 😀

[atcodedog05]

Hi @joannasokolowska 

Just to add to the above solution if you have files of different formats in the same folder you want to row count of all them you can refer to this weekly challenge where they handle multiple file formats in a single batch macro.

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-180-Thousand-File-Challenge/td-p/461356

Hope this helps : )