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 .