Using Factors in Data Management Import Formats
Import expressions can be added to an FDMEE import format to alter the data being imported from a file in several valuable ways. In this blog, I will focus on using the ‘Factor’ import expression, which allows you to multiply your data by any whole number or decimal factor. This means that you can scale the file data effortlessly by any numeric factor. The syntax for this expression is Factor=Value, where the value is the user-defined whole or decimal number you wish to multiply your data by. The import expression should be entered in the 'Expression' field for the 'Amount' source column. Listed below are a few things to consider when applying a factor to your data: Factors are only applied when the import format Data Type is set to one of the following Delimited–Numeric data Fixed–Numeric data Multi-Column–Numeric Data The factor will be applied to all data amounts in the file. When importing a multi-column file with Accou...