Enterworks - ETT 158 - Normalizing DECIMAL/CURRENCY Columns in Export Files

When exporting repository data that includes DECIMAL attributes, the values will match what was entered in the UI, API call or imported from a file.  This means that the same value can be represented in various ways.  For example, the value 23 can be entered as 23, 23., 23.0, 23.000, etc.  While all of these values are identical, when comparing data as strings, they are all different.  If padding is enabled for each DECIMAL/CURRENCY attribute, the values will be padded with zeroes to the right of the decimal, but it may not be possible for this to be set on each attribute and the file being compared might not originate from Enterworks.  In cases where consistency with decimal values is needed, a scheduled Export Post-Processor to normalize the decimal values can be used to ensure decimal values are reduced to their bare-minimum for comparison purposes.

This session covers how to configure and use the EW_NormalizeDecimalValues Post-Processor.

 Prerequisites - ETT 053