Max

[raadwiptec]

I have 2 Different Tables which does not have any matching Columns

Table A

SalesID

Location 

Sales amount

Retro amount

Written amount

Table B

Account ID

Gross Amount

signed amount

I would like to take Max(Min(Max(Min(Max of Sales Amount and Gross Amount...,0),Signed Amount),Retro Amount),0)

and would like to do only on script

[Kushal_Chawda]

@raadwiptec  can you please elaborate

[raadwiptec]

I have 2 files which i have loaded as Table A and Table B in the Load script ... Loaded as below 

Table A

SalesID

Location 

Sales amount

Retro amount

Written amount

Table B

Account ID

Gross Amount

signed amount

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 .?

[Kushal_Chawda]

@raadwiptec  Can you share sample example with expected output?