Select the data transformer checkbox to manipulate actual data contained in the files you upload.
Such as transforming currency data to include a zero before the decimal point. For example: .5 (½) appears as 5 and is calculated as a whole number instead of 0.5. The Data transformer adds the necessary zeros to currency data.
- Navigate to the Import tab.
- Expand Data Streams List.
- Create a data stream, or edit an existing one.
- In the Preview Source screen, click Edit Transformers.
- In the Add Transformers section, next to Data, click the plus icon.
- Select the checkbox and click Done.