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]);
