I have two fields:
I'd like to create a third field in the script with the sum of the 2. Is that posssible?
Thanks in advance!
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).
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
Both worked and the rangesum took care of non-# entries. Thanks!
Retrieving data ...