How do I just figure out the number of rows in my dataset?

[Trifacta_Alumni · Accepted solution]

Hi Jenna,

You can figure out the number of row in your dataset by using the count function. Try this: AGGREGATE with COUNT(). This will return the number of rows in your dataset when you run your job. If you are using sampling and would like to know how many rows are in your sample, you can find this in the bottom left of your grid screen.

Karli

[Conner_Tri]

Ah, that makes sense. Thanks!

[ccarreras]

I think you can also see the number of rows in your dataset by running a job with profiling enabled. The job results profile shows you the total number of rows in the output at the top of the screen. So if you have no steps in your recipe, this will basically profile your input.