Excel File: Get name of table and numbers of records.

[neromerob]

Hello to everyone

I`m trying to build a workflow that allows me to get several tables and get their names and numbers of records into an Excel file.

Something like this.

I have to do  this with several tables so any help will be welcome.

Thank you.

[DataNath]

@neromerob do they all have the same schema? I.e it’ll only ever be the 2 Name and Code columns? Also, when you say you have multiple tables, what form are these in? Multiple Excel files that you want to count records of and consolidate into one?

[binu_acs]

@neromerob one way of doing this with the batch macros

[ArtApa · Accepted solution]

Hi @neromerob - If your data always looks like this then it's a two tool workflow: