i want know how many rows are there in the table?

[#1]

i want know how many rows are there in the table?

[tresesco]

NoOfRows('TableName ')               // in the script

NoOfRows([total])                           // Front end chart

[#3]

NoofRows('tablename')

NoofFields('tablename')

NoofFields('qvdname')

Hope it helps.......

mark as correct answer

[er_mohit]

Hi use noofrows() function

NoOfRows('TableName ' )

Returns the number of rows (records) in a previously loaded table.

If the function is used within a load statement, it must not reference the table currently being loaded.

Examples:

LET a = NoOfRows('tab1');

Load * from abc.csv where NoOfRows( )<30;

[ngulliver]

Hi, Manoj.

Another option is to add a line of code into your load script.

1 as RowCount.

Then all you do in your front end is sum(RowCount).

Cheers,

Neil