KBA KB0401779
FAQ
Question

How to use the Number Format function for Decimals in Cloud Integration Gateway (CIG) Mapping Tool?

Answer

To manipulate decimals in CIG using the number format function on the Mapping Tool, please follow the steps below:

  1. Select a field from sourcing which you want to apply the function and map to a target field
  2. Right click on the mapping line
  3. Click Functions > Add Function > Add Format Number Function
  4. Add the desired Number Format Pattern with the desired decimals quantity, for example with two decimals the pattern should be: .00
Additional Information

For detailed steps see also How to use the Number Format function for Decimals in CIG Mapping Tool - Cloud Integration Gateway