6 Replies Latest reply: May 4, 2012 10:53 AM by jkizanis RSS

    Transfer data from field1 to field2 during load

      Hello,

       

      I have a table like the following:

       

      NameHoursKg
      George3150
      John1175
      Mike8220
      Mike4134
      George3215
      John4100

       

      I use the load statement

      LOAD

                Name,

                Hours,

                Kg

      FROM [c:\test1.xls] (biff, embedded labels, table is [Sheet1$]);

       

      I would like to change the load in such a way, that whenever the name is John, the Hours get transferred to George's Hours, but the Kg stay with John. Therefore, the internal table should resemble the following:

       

      NameHoursKg
      George3150
      George10
      John0175
      Mike8220
      Mike4134
      George3215
      George40
      John0100

       

      Do you have any idea of how to accomplish this?

       

      Thanks,

       

      --John