Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to convert values in a field from negative to positive and where it is poritive to negative at the script level.
Please help.
Regards,
Utsav
got it done using the following command:
if(value<0,value*-1,value*-1)
Thanks
multiply the field by (-1) to get the new field.
Hi Utsav,
Did you try this yet
LOAD
...
Field * -1 AS [Value],
...
Regards,
Sokkorn
Hi Everyone,
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.
Regards,
Utsav
try using a LOAD statement over the SELECT statement. Like:
Load
F1 *(-1) as NewF1;
SQL Select
F1
From ....;
Ok
it seems you can do it
like this
LOAD -1* fieldname as New,
B,
C,
D;
SQL SELECT * from tablename;
hope t helps
got it done using the following command:
if(value<0,value*-1,value*-1)
Thanks