1 Reply Latest reply: Jul 2, 2012 10:50 AM by Jonathan Dienst RSS

    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

        • Re: Table loop
          Jonathan Dienst

          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