2 Replies Latest reply: Jun 12, 2014 5:35 AM by Ralf Becher RSS

    loop

      hi !!

      i have this table in the picture posted below and i want to add a new column where, for each row, appear only the name of the column that contain "1". What kind of string should i use to obtain this result??

      Thx

      PR1.JPG.jpg

        • Re: loop
          Kiran Rode

          hi Gabriele,

           

          which object  u r using straight table ,Table box or pivot table for desired output?

          • Re: loop
            Ralf Becher

            Hi Gabriele,

             

            basically, this is a Crosstable problem:

             

            Data:
            LOAD * INLINE [
                F1, a, c, d, f, g, b, e, h
                R1, 0, 0, 0, 0, 0, 0, 1, 0
                R2, 0, 0, 0, 0, 0, 1, 0, 0
                R3, 0, 0, 0, 0, 0, 0, 0, 1
                R4, 0, 0, 0, 1, 0, 0, 0, 0
                R5, 0, 0, 0, 0, 0, 0, 1, 0
            ];
            
            Cross:
            CrossTable(Field, Value) LOAD * RESIDENT Data;
            
            LEFT JOIN(Data) LOAD F1, Field Resident Cross Where Value=1;
            
            Drop Tables Cross;
            
            
            
            

             

            - Ralf