Hi all,
I have the following two tables (you may also refer to attachment)
Table A
Person Index Symbol
Inna - T1 - alpha
Inna - T4 - beta, theta, delta
Maria - T1 - delta, theta
Maria - T4 - alpha, gamma
And
Table Conversion
Symbol Index Combination Symbol value
Alpha - alphaT1 - 10
Beta - betaT1 - 18
Gamma - gammaT1 - 14
Delta - deltaT1 - 100
Theta - thetaT1 - 1
Alpha - alphaT4 - 10
Beta - betaT4 - 18
Gamma - gammaT4 - 14
Delta - deltaT4 - 100
Theta - thetaT4 - 1
And the idea is to get:
Table Outcome
Person SymbolValues Lowest Value
Inna - 10- 10
Inna - 18,100,1 - 1
Maria - 100,1 - 1
Maria - 10,14 - 10
Logic: in table Conversion we look for the symbol value on basis of Index and Symbol from Table A; these values get populated in Symbol value in table Outcome and then we need the Lowest Value of the latter in column Lowest Value Table Outcome.
Does anyone know how this could be done?
Thank you VERY VERY much!