Count rows in a Table, Count special characters
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Solved! Go to Solution.
- Labels:
- Common Use Cases
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Preet2020 - Here is a macro that accomplishes what you want for step 1.
Thanks, let me know if this works for you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you. Solution works