topic Re: Count number of rows for all files in folder in Alteryx Designer Desktop Discussions

Count number of rows for all files in folder

joannasokolowska — Fri, 25 Feb 2022 15:18:54 GMT

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

Re: Count number of rows for all files in folder

binu_acs — Fri, 25 Feb 2022 15:28:26 GMT

@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/ta-p/20480

Re: Count number of rows for all files in folder

Qiu — Fri, 25 Feb 2022 23:52:33 GMT

@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. 😁

Re: Count number of rows for all files in folder

joannasokolowska — Sat, 26 Feb 2022 15:22:59 GMT

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

Re: Count number of rows for all files in folder

joannasokolowska — Sat, 26 Feb 2022 15:24:43 GMT

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 :)

Re: Count number of rows for all files in folder

atcodedog05 — Sat, 26 Feb 2022 15:30:47 GMT

Amazing solution @binu_acs 🙂 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 😀

Re: Count number of rows for all files in folder

atcodedog05 — Sat, 26 Feb 2022 15:50:37 GMT

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 : )