2 Replies Latest reply: Jan 14, 2017 3:52 PM by Girirajsinh Vaghela RSS

    Using applymap with dimension keys...

    MARK PERRONE

      I wonder if I can use applymap to get the dimension keys..

      Usually, I see mapping used for getting say, the category from the product table.

       

      I've read about how applymap can reduce the size of the document which I what I am hoping to achieve.

       

      Thanks in advance.

       

      Products:

      MAPPING LOAD

        autonumber(product,'product') as productkey,

        product

      ;

      SELECT

        product

      FROM

        PRODUCTS

      ;

       

      LOAD

        orderid,

        applymap('Products',product) as productkey,

        quantity

      SELECT

        orderid,

        product,

        quantity

      FROM

        ORDERS

      ;