11 Replies Latest reply: Sep 10, 2011 9:03 AM by Nenad Vukovic RSS

    Why the ApplyMap does not work when concatenation is used?

      XY_Map:
      mapping load
      '$(vComp)'&'-'&FIELD1 as ID,
      FIELD1&'-'&FIELD2 as Desc;
      select FIELD1, FIELD2 from SQL_TABLE;
      Fact:
      load
      ...
      applymap('XY_Map', '$(vComp)'&'-'&left(FIELD99,7)) as Desc,
      ...
      select FIELD99 from SQL_FACT_TABLE;