Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
jontydkpi
Not applicable

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