Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

Status Not Planned
Workspace Jedox Platform
Categories Integrator
Created by Guest
Created on Aug 6, 2021

row count of a component in scripting

using the following:

source = API.initSource('myextract');

count = 0;

while (source.nextRow()) {

count++;

}

this would be great to have a method to get the rowcount directly, e.g.:

count = source.rowCount();

if I want toto iterate over the source if there are rows, I have 2 times instead of once.


this should not be very complex since the rowcount is already available in the log:

Lines read from extract myextract: xxx

  • Guest
    Reply
    |
    Sep 9, 2021

    The issue here is that we must read all the rows to get the rowcount, so this could be slow on a large dataset. This would not therefore provide the benifit that user would be expecting.