Changing the field type in the XML or CSV step input in Atrium Integrator Spoon
By default, the type for all mapped fields that are listed in the XML or CSV step input is set to String. Based on your requirements, you can manually change the type for specific fields.
To change the field type listed in the XML and XML or CSVstep input
- Open your transformation in Atrium Integrator Spoon. For more information, see Opening Atrium Integrator job or transformation.
- Double-click the XML or CSV step input.
- On the Fields tab, identify the field for which you want to change the type.
- From the Type column, select the appropriate type.
For Datetype, select the appropriate date format. The date format must be as specified in the XML file or CSV file.
- Click OK.
For information about supported external data store types see, Atrium Integrator supported data types.