Calculations while importing

[#1]

I need a field, Expense, to be multiplied by (-1) at the time of importing itself, is that possible? I do not want to write that in the expression for each object throughout the file, which is what i do at present. Following is a snippet of the code:

Load*,

[Expense],

from ...abc.XLS

[kaushiknsolanki · Accepted solution]

Try this.

Load *,Expense * -1 as New_Expense

From abc.XLS

Regards,

Kaushik Solanki