Count number of rows for all files in folder

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

Workflow

Accepted answers

binu_acs

@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

All comments

binu_acs

@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

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703