Load multiple Excel files from a directory with one connection and extract (like CSV Files).
Load multiple Excel files from a directory with one connection and extract (like CSV Files). Basically the same structure like creating a file extract using a folder-connection. But also working with Excel files :)
Our Partner had the following request: We need some of the jobs to be able to run when a long job is already running but they shouldn't run when other jobs are running.This means we cannot set them as standard and cannot set them as parallel.The i...
Little Icon (i) which can lead to the exact article in the KB. For example, in table join, i would take to https://knowledgebase.jedox.com/integration/transforms/tablejoin-transform.htm?Highlight=table%20join
When creating ETL project, a lot of debugging is needed. At this moment to check if data is correct, I'm exporting data to CSV right from DataPreview vindow. The problem - it exports only data visible on screen.
Sure - with BIG data, it is ok.
...
when previewing data you sometimes want to copy a particular value, without exporting the whole preview. Copying strings directly from the preview would be nice, e.g. per right-click
Create Load/Transform from Extract and Load from transform
in the flow of creating new models we commonly create Extract, Transform and Load for each dimension. It would be nice to create a transform right from the editing window of an extract and jump right into it's settings, to edit it directly.
For very large tables in SAP it tooks a long time to select all fields to export. It would be nice if there is a select option to export all existing fields of a SAP-Table by one click.
Ability to create new folders in the Designer and Reporter using the Integrator
At the moment Designer and Reporter folders can only be created manually. It would be nice to be able to automate this process, especially when dealing with multiple use cases that all require individual folder creation.
Add JedoxFiles option to the location parameter in the Directory Connection
Dear Jedox, What: Please expand the location parameter with the option "JedoxFiles" in the directory connection. This option already exists in the CSV and Excel connection. Why: The directory connection is very useful for file management. Please l...