multiple IF in Load

[vpanchuda]

I am new to QLik

I want to script multiple conditions in load and get an additional field to work further .

Below i have created an inline table with Field C-ID  which have A1,A2 and A3 

and an xml table where the Remarks shall be YES, NO or/N

Question - how to script condition IF C-ID from Template (INLINE TABLE) is A3 and Remark from Result Table is YES then it should give an additional field  called Score as 3 ,IF C-ID  'A2' and Remark from Result Table is YES then it should give an additional field  called Score as 2 ,,IF C-ID  'A1' and Remark from Result Table is YES then it should be Score as 2 , else 0.

//First Table

Template:
LOAD * INLINE [
C-ID,C-Category
A2, VBB
A1,VCC
A3,VDD
A2,VEE
A3,VFF
A1,VGG
A3,VHH

];

//Second Table

Result:
LOAD
C-ID,
Remark,

FROM (XmlSimple, table is [result]);