Alteryx load multiple files - fetch row counts using batch macro

[somnathsolaskar14]

Hello,

I have set of directories/sub-directories with a lot of csv, xlsx files inside it. These files again have sheets inside them.

I am trying to extract the row count of the records in each of these files/sheets.

Since I have more than 900 files in different directories , I cannot build individual workflow for each one of them.

Batch macro is one of the way i found out but was unable to develop it.

If anyone helps me out here, it would be a great help.

[davidskaife]

Hi @somnathsolaskar14 

Where did you get stuck with developing the batch macro? A simple solution is explained here that may assist if you haven't seen it already - https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/t...

[binuacs]

@somnathsolaskar14 one way of dong this with the help of two bath macros. First batch macro pulls all the .xlsx files and respective tab names and the second batch macro to take the count of each tabs from the input .xlsx files.

Note: you can change the .xlsx in to *.* in the directory tool to pull all the files in the folder/sub folder.

[hi2019]

Hi so I need to get row count from .csv files from one folder - I copied what you had but the sheet macro doesnt apply to csv files correct? how do I get past this point and get the count? I see the filename but I only need the total row count without counting header.

Any guidance would be so helpful.