I need to convert values in a field from negative to positive and where it is poritive to negative at the script level.
multiply the field by (-1) to get the new field.
Did you try this yet
Field * -1 AS [Value],
yes i have tried it al but does not work.
I am using a select statement to while loading data from database...and along with it i want to use the multiply by -1 thing.
try using a LOAD statement over the SELECT statement. Like:
F1 *(-1) as NewF1;
it seems you can do it
LOAD -1* fieldname as New,
SQL SELECT * from tablename;
hope t helps
got it done using the following command:
Retrieving data ...