Making multiple field calculation into one same field

[remo0017]

Hi Everyone,

  I have a situation where i need to bring in all calculated if conditions into one single same field. Please help me to get this logic correct to the field T1 will have (B1, B2, B3) as its result set for the below conditions.

if ((field1='A1' and field2='B1'), B1) as T1

if ((field1='A2' and field2='B2'), B2) as T1

if ((field1='A3' and field2='B3'), B3) as T1

Result set:

T1: B1, B2, B3.

Thanks very much,

[YoussefBelloum]

Hi

try this:

if((field1='A1' and field2='B1'), 'B1', if((field1='A2' and field2='B2'), 'B2', if((field1='A3' and field2='B3'), 'B3'))) as T1