How can I add 2 fields in the script and create a new field with the sum?

[#1]

I have two fields:

'Salary' 'Bonus'

I'd like to create a third field in the script with the sum of the 2. Is that posssible?

Thanks in advance!

[#2]

Totally possible. Simply add the expression within your load script, e.g. 'Salary' + 'Bonus' AS 'Salary_Inc_Bonus' (or however you wish to name your new field).

[hector · Accepted solution]

It's possible if you sum the 2 fields like the previous post said, but just to be sure that there are not NULL values, maybe you can use

rangesum(Salary,Bonus) as Salary_plus_Bonus

rgds

[#4]

Both worked and the rangesum took care of non-# entries. Thanks!