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 ...
Retrieve information from parent node in JSON extract
When hierarchical data is retrieved from a REST endpoint, it's really cumbersome to get that data into a dimension. Imagine, your JSON data has the following hierarchy: Legal entity > Function Area > Cost Center Naturally you'd configure you...
Expand column aggregation to include more than 2 column inputs
It would be great to be able to add additional columns in the Column Aggregation Transformation Function so the aggregation can be calculated based on the unique dimension elements from another column. Currently, it allows max two columns but woul...
Only stop the services when no Integrator job is running
We have implemented on our own systems that the restart of the services, which is carried out during the backup, only takes place when an ETL job is no longer running. This is also necessary for the cloud.
It would be helpful if you could choose whether a CSV or Excel file should be created when exporting ETL DATA PREVIEW. As is the case when exporting drill-through data.
when a component refers to several sources (e.g. FieldTransform with n lookups) it would be nice to highlight the "main" source in the flowchart (for instance a bold line)
Integrator - Values in Data Preview with options should stay during session
The "data preview with options" is a helpful feature to look at data points without having to change the default value of variables. However it would be nice, if the values are saved during the session to look at different component data previews ...
Add a property to loads and jobs that show all dependency in report designer
Actually, it could be very tipsy if there is a way to know where a job or a load is called. For example on a report there is button with action that call an integrator job A. We could add a property to this job that show the path of the report tha...
Add a checkbox to return absolute value in function DateDuration
When we use the function DateDuration in ETL Fieldtransform it return a subtraction between 2 date, but sometime we don't care about if the date difference (in terms of days for example) is positive or negative so in this case it should be interes...