Row Count, regardless of uniqueness

Ask a question
1

We used to be able to utilize a feature I believe called Group, where I could count the number of rows in an output. I don’t seem to be able to find it anywhere now with the new updates.

  1. Did we get rid of this one?
  2. How can I count the number of rows in a list and just tell me how many rows are in the output? I don’t want a count of unique values, I need just a count of the rows themselves.

Any help would be massively helpful!

Clay

2

Hi Clay! Thanks for your question. Here’s the announcement we made about the updated Group By steps.

  1. The step you’re looking for is now called the Count Values step.
  2. For this, you can always see the total number of rows within a step. It would say something like “x rows, y columns” at the top. If you need to output that number, you can either add a Row Number step, if you don’t already have an ID for your table, and then count that column using the Count Values step.

Does that answer your questions?

1 Like