10 Replies Latest reply: Jun 21, 2017 6:46 AM by Lukas B�denbender RSS

    Distinct Applymap

    Lukas B�denbender

      Dear All,

      I got a mapping Table with 'Object Number' and 'Order Income':

       

      Map_OrderIncome:

      mapping load Distinct

      Object.Number,

      Order.Income

      Resident

      CE1;

       

      this should be mapped to the Facttable

       

      Fact:

      load

      *,

        ApplyMap('Map_OrderIncome',Object.Number,'') as Order.Income //

      Resident

      Fact_temp;

       

      The result is as follows:

       

      Sales Number     Object Number    (i.e.)  Document Number     Order Income

      1234                    1234_1                         123456789                    1.000

      1234                    1234_2                         123456788                    1.000

      1234                    1234_2                         123456788                    1.000

      ...

       

      But the result should be

      Sales Number     Object Number    (i.e.)  Document Number     Order Income

      1234                    1234_1                         123456789                    1.000

      1234                    1234_2                         123456788                    1.000

      1234                    1234_2                         123456788                       -

      ...

       

      I want to have just one record per Object Number in my Table. Is this possible?

       

      Thanks in advance

       

      Lukas