3 Replies Latest reply: Sep 14, 2017 10:14 AM by Michele De Nardi RSS

    Load Expression from excel and use them during load

    Michele De Nardi

      Hi guys,

      i have two tables structured as below:

       

      MAPPING_TABLE:

      MapKeyMapFormula
      aField1+Field2+Field3
      bField1+Field2+Field3
      cField1+Field2+Field3
      dField1+Field2+Field3

       

      FACT_TABLE:

      KeyField1Field2Field3
      a111
      b222
      c333
      d444

       

       

      and i would like to use the declared formulas on this mapping table to obtain resulst on another table...so:

      MAPPING_TABLE:
      Mapping
      Load
           MapKey,
           MapFormula
      
      From MAPPING_TABLE.xls;
      
      FACT_TABLE:
      Load
           Key,
           Field1,
           Field2,
           Field3,
           Applymap('MAPPING_TABLE',Key) as Result
      From FACT_TABLE.qvd(qvd);
      
      
      
      

       

       

      but the resut is

      KeyResult
      aField1+Field2+Field3
      bField1+Field2+Field3
      cField1+Field2+Field3
      dField1+Field2+Field3

       

      and i would like to obtain:

      KeyResult
      a3
      b6
      c9
      d12

       

       

      Any idea ?