I think so ... instead of using SID in the 2nd arguement of applymap() try just putting Right([Functional loc.],6).
Then you can do it in 1 load.
Or maybe a preceding load to keep your right() expression written in only 1 place
applymap( <argument1>, SID, etc...)
Right([Functional loc.],6) as SID
I agree with Jonathan Poole , using a preceding load is an elegant way to do it in 1 load!
It looks like you're trying to split [Functional loc.] using '-' as delimiter so you can use Subfield() instead of Right():
Subfield([Functional loc.],'-',2) as SID,