Important: Java FieldTransform function is deprecated in Jedox 2019.1 and will no longer work as of Jedox 2019.2.

Any public Java class method can be used for fieldwise transformation. This provides a wide range of transformation possibilities. During the transformation process, the method is processed with the input of each row of the transform.

Parameters

Class	The Java class (i.e. its constructor). It can be static.
Method	The name of the public method in the Java class. The method can have one or several input parameters and a return value, all of simple data types.

The input fields of the function are assigned to the parameters of the Java class constructor and/or the Java method: the first input is assigned to the first parameter, the second input to the second parameter, etc.

Each input field requires the following specifications:

Input	The name of the input field (as for other functions in a FieldTransform).
Type	A data type that has to match the corresponding parameter type in the Java method. If specified, the input field is converted to this data type. The possible values are: string (default), double, int, byte, float, short, long, and object.
Target	class: for input fields of the constructor class  method: for parameters of the method class

If the Java class is not part of the JRE (like e.g. java.lang.String), it has to be copied to the Jedox Integrator installation. To do this, perform the following actions:

• Stop the JedoxSuiteTomcatService service 
• Copy the .class or .jar file of the Java class to the .\tomcat\webapps\etlserver\WEB-INF\lib_external folder.
• Start the JedoxSuiteTomcatService service

For the generation of the Java class file, the same JDK version used for the Jedox Integrator installation should be used to avoid compatibility issues.

Example