Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Not applicable

Table loop

Hello everyone

I need your help with something

I have a number of fields in a table, let's say I have  a field1 and Field2 , i need to create a new column called condition .

for each value in Field1 if Value exists in Field2 than condition=0, else condition=1.

Thank  you in advance for your help

1 Reply
Highlighted
MVP
MVP

Re: Table loop

Hi

In your load script, assuming that you have loaded Field2 first:

          LOAD

               ...

               Field1,

               If(Exists(Field2, Field1), 0, 1) As Condition,

               ...

          From ...;

You could also do this with join using the table containing Field1.

Hope that helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein