Currently the ETL flow graph can get confusing/insane large if there're many steps. We need to find a better way to filter/re org the information/flow.
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 ...
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...
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.
in the new ETL Project overview, add group expand/collapse and search bar
THe new project overview screens in integrator are great, but what would make the finctionality much better is the ability to: Collapse/Expand the groups of components Adding of a search bar at the top for the components.
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)
Table Join (left outer) - Checkbox to show only nulls on right side of join
To do this currently requires a Table View step to filter out records that are not null on the right side of the join. It would be simpler to have a check box next to the join type that only shows up when 'left outer' is selected. When checked, th...
It's necessary to have an option of Partial Reload in the Integrator Qlik Load. Qlik Sense supports it. And it saves a lot of time during data sinchronization between Jedox and Qlik.