Count rows in a Table, Count special characters

[Preet2020]

I have two questions:

One - I have multiple Input tables in a workflow, and i want to know the number of rows and columns in each table. I can get this info by going to the result of each table but it is very cumbersome to open each tablefor the Row and column count. Is there an easier way to get count of rows and columns by defining a query?

Two - How do i get count of rows in a field which has hyphen or any other special characters?

[Blake]

Hi @Preet2020 Check out the attached workflow and let me know if it works for you. I gave two options on the first question, depending on how you want to handle your data.

[RobertOdera]

Hi, @Preet2020 

Kindly provide a sample file.

In the meantime:

1. To get row count

You can use Count Records Tool or Record ID Tool + Running Total Tool or  Summarize Tool or (this is Alteryx! there are many options/ approaches)

2. To get conditional row count

Regex on the condition or Filter Tool calc on the condition or Formula Tool calc on the condition or Multified on the condition or Multi-row on the condition (again, many options/ approaches).

And then perform step 1 on the rows that satisfy the condition

Please note that your conditional approach can be negative. For example, depending on the target, If Contains or If NOT Contains (!Contains)

Good Luck!

[Preet2020]

Thank you, the solution for the 1st question works but it is lengthier considering the number of tables i have in the workflow. i was looking for a more easier solution to handle this requirement. 

[Blake · Accepted solution]

 @Preet2020  - Here is a macro that accomplishes what you want for step 1. 

Thanks, let me know if this works for you.

[Preet2020]

Thank you. Solution works