Convert into Number decimal and text combination

techvarun — Mon, 11 May 2015 05:27:49 GMT

Hi Qlixperts

I am trying to covert a huge fields into number by the script below

LOAD num(Value_EUR),

-1* num(Value_EUR),

Value_EUR as Value_EUR_Actual

The field Value_EUR contains combination of numbers and texts and in the num(Value_EUR), field i am getting all the text fields as null

Please help me fixing the code

Re: Convert into Number decimal and text combination

tresB — Mon, 11 May 2015 06:05:00 GMT

try like:

LOAD Evaluate(Value_EUR),