4 Replies Latest reply: Jun 26, 2017 6:05 PM by Axel Vazquez RSS

    Reply value wich is in the same column

    Axel Vazquez

      Hi everyone ! I have an excel to import wich have two columns, one of those, have the code and the group and the other column has the description .

       

      Like this :

       

      CODE          DESCRIPTION

       

      EXAMPLE1     abcde

      102030             abcde

      10424               abcde

      EXAMPLE2     skdfslk   

      11234               sdkf

      32809                lsksj

      94385               klajlkfj 

       

      I need to be finish like this :

       

      CODE          DESCRIPTION            CODE_NAME

       

      EXAMPLE1     abcde                    EXAMPLE1    

      102030             abcde                    EXAMPLE1    

      10424               abcde                    EXAMPLE1    

      EXAMPLE2     skdfslk                   EXAMPLE2    

      11234               sdkf                    EXAMPLE2    

      32809                lsksj                    EXAMPLE2    

      94385               klajlkfj                 EXAMPLE2    


      I 've already try to use for each like this :


      for each a in FieldValueList('B')

      LOAD if(WildMatch($(a),'CAPITULO*')>0,$(a)) as Capitulo AutoGenerate 2;

      NEXT a

       

      But it doesn't work