2 Replies Latest reply: Nov 30, 2013 12:17 PM by gidon david RSS

    Add field during load

    gidon david

      Hi guys

      I have a problem to solve  !!

       

      enclosed attached excel file trans

       

      first column is name

      second is new trans if y it is new

      third id transnum

       

      I need to add the forth column GroupNum ,

      a group gets GroupNum , where newtran='y ' , GroupNum=TranNum

      all lines that follow this line until the next 'y' with same Name ( not includes ) 

      All Lines get the GroupNum from the line which  newtran = 'y'

       

      the enclosed file expalin it better .

       

      thanks

       

      gidon