Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have to import a csv file but the numerical column appears as below. May I know how can I make to to numeric format?
Thank you very much for your advice Kush. Unfortunately, I still cannot get the required result.
I later get it resolved by using num(Evaluate(field))
@43918084 Maye Num() function ?
Load *,Num(Field) as NewField inline
[
Field
+000025
-000055
+000111
-001111
]
output:
@43918084 if it is stored as text then try below
num(num#(Field))
Thank you very much for your advice Kush. Unfortunately, I still cannot get the required result.
I later get it resolved by using num(Evaluate(field))