how to create one field from the table based on 2 different fields

[#1]

Hi,

i have 2 fields in one table, need to derive one more field based on the 2 existing fields, please suggest me how to achieve this.

[anbu1984]

Tbl1:

Load * Inline [

Field1,Field2,Field3

x,a,12

x,b,11

y,a,13

y,b,11 ];

Left Join(Tbl1)

Load Field1,If(Sum(Field1='x' And Field2='b'),'Y','N') As Op Resident Tbl1 Group by Field1;