1 Reply Latest reply: Jul 14, 2016 1:56 AM by arul settu RSS

    How Mapping can be used when a column doesnt exist in a table ?

    Nishanthi Rajendran

      I have two tables concatenated and there doesnt exist a column name in one of the table. How it can be achieved via ApplyMap() ?

       

       

      DIMENSION TABLE:

      USER ID,

      ORG SUB_CATEGORY;

       

      CONCATENATE

      USER ID,

      ORG NAME,

      ORG SUB_CATEGORY;

       

           In the above example i need ORG NAME to be used in ApplyMap() so that ORG SUB_CATEGORY can also be used for further manipulations.