Entrance Java Computing
The computation is done during file import, line by line. This is the reason why 'run operation' button is disabled. It means that if you modify the java code, you have to empty data and import files again.
It means also you can't use “_doJava.get” method in your code.
Usually we create an entrance java to have a main index that doesn't exist in the file. You can use the filename to extract information, you can also concatenate the date and the time in two different columns to have a complete Timestamp.
💡 Entrance Java computing can be used as parameter in an Original pivot, but not in another Entrance Java computing ; all Entrance Java are computed at the same time.
Pivot original
The original pivot is the same as the pivot, but it is created in an Original table.
Its enables to efficiently treat list files.
If the columns "Index", "Tag" and "Value" of the file do not suit you, thanks to the "Entrance Java Computing" you can create:
- a new index column (to create a clean datetime for example)
- a new Tag column (to concatenate 2 columns for example)
- a new value column (to remove NULL values for example)
Here you can add as many optional columns as you need. The value still has to remain the same for each index value, or else it will be overwritten.
THE INDEX OF THE ORIGINAL PIVOT MUST BE THE SAME AS THE MAIN INDEX OF THE ORIGINAL TABLE.
As the original pivot runs during the file importation, if you modify a parameter, you have to empty the table and import files again.
Entrance Group by (original aggregation)
Aggregates the data during the importation of the file. It works only if all your data aggregates in the same file.
Only available on Original tables
Not stable ==> use it at your own risks
Don't forget that your "Group by variable" = your main index.