Multi Column = All Data Type with Factor
Hi Team,
We are using multi column all data type for a particular import fomat as the source file contains data values in columns lke year_1, year_2, year_3 etc, hence we have used driver fucntionality to specify the header for each column and also define the same in import format. Please see the below screenshot
Now we need to factor the amount with 1000, I tried adding factor before and after the above parameters but even though it gets saved correctly, the amount/data is not multiplied. Any pointer why the factor wouldnt work with Multi-column All datatypes? I tried with Numeric data type and it works correctly.