Script Logic

[sona_sa]

Hi,

I have 2 sheet, i.e Sheet1 and Sheet2. In Sheet1 One field is Test and in another Sheet2, One field is Test2.

I have to match the value with Sheet 1 and Sheet 2 and create a new field, i.e Test1.

Like : If value of Sheet 1 : Test = Sheet 2 : Test2, then return me 1, else return me 0. For more reference, Please find the attached xls.

Output filed is also there, i.e - Test1.

Thanks in advance.

[sunny_talwar]

Is this what you are looking for? (PFA)

Best,

Sunny

[sona_sa]

Yes, but can we do the same by using nested if - else condition and group by function.

Thanks for reply.

[MarcoWedel]

Hi,

another solution could be:

tabSheet2:
LOAD Test2
FROM [https://community.qlik.com/servlet/JiveServlet/download/771370-163411/Test.xlsx]
(ooxml, embedded labels, table is Sheet2);

tabSheet1:
LOAD Test,
    fabs(Exists(Test2,Test)) as Test1
FROM [https://community.qlik.com/servlet/JiveServlet/download/771370-163411/Test.xlsx]
(ooxml, embedded labels, table is Sheet1);

hope this helps

regards

Marco

[MarcoWedel]

or just

-Exists(Test2,Test) as Test1

instead of

fabs(Exists(Test2,Test)) as Test1

hope this helps

regards

Marco