topic Set a variable with the total number of rows in App Development

Set a variable with the total number of rows

Morgoz — Thu, 15 Apr 2021 15:21:47 GMT

Hello,

I need to set a variable with the total number of rows from a table.

To achieve this, I've done the following:

TOTAL_ERRORES: LOAD Count(ID_REGISTRY) as total_errores RESIDENT DQ_REGISTRY; LET total_errores = if(isnull(Peek(total_errores,0,TOTAL_ERRORES)),0,Peek(total_errores,0,TOTAL_ERRORES));

Could you please tell me if this is the better/simpler way to do it?

Thank you.

Re: Set a variable with the total number of rows

GaryGiles — Thu, 15 Apr 2021 18:14:02 GMT

Try using the NoOfRows() function:

Let total_errors = NoOfRows('TOTAL_ERRORES')

Re: Set a variable with the total number of rows

Morgoz — Wed, 21 Apr 2021 09:37:09 GMT

Thak you Gary,

anyway, the correct expression was

Let total_errors = NoOfRows('DQ_REGISTRY')

But it works. Thanks.