I have 2 files which i have loaded as Table A and Table B in the Load script ... Loaded as below
I would like to make a new field Called 'Range' -- > Max(Min(Max(Min(Max of Sales Amount and Gross Amount...,0),Signed Amount),Retro Amount),0) . But i would like to put this the new field using script;
Is this possible to link these tables somehow and then create this new field .?