0 Replies Latest reply: Dec 7, 2011 3:58 PM by pattarav.s RSS

    Concatenate two fields

      Hello,

       

      I want to concatenate two columns as below:

      BLS-before.png

      BLS-after.png

       

      How could I do that?

       

      My script is:-

       

      BranchMap:

      MAPPING

      LOAD BR_Code_IOC_Code,

           Branch_Number     

      FROM

      branchMap.xlsx

      (ooxml, embedded labels, table is Sheet1);

       

       

      BLS_GGLMap:

      MAPPING

      LOAD GGL_Code,

           BLS_Item_GGL

           //RowNo()

      FROM

      balancesheetitemMap_GGL.xlsx

      (ooxml, embedded labels, table is Sheet1);

       

       

      LOAD '024' AS Organization_Id,

           '14034' AS BLS_Amount_Type,

           '116002' AS Reporting_Group_Id,

           GL_Code,

           ApplyMap('BLS_GGLMap',GL_Code) as BLS_Item,

           InsideOutside_Country_Indicator,

           Trx_Currency_Code,

           Book_Currency_Code,

           Branch_Code,

           Cost_Center_Code,

           ApplyMap('BranchMap',Branch_Code&Cost_Center_Code&InsideOutside_Country_Indicator) AS Branch_Number_Rpt,

           Class_Key,

           PL_BS_Indicator,

           GL_Code_Description,

           Amount,

           Load_Source,

           Snapshot_Date

      FROM

      [GGL Table.xlsx]

      (ooxml, embedded labels, table is Sheet1)

      WHERE(Class_Key = 'A');

       

       

      LOAD Cust_Number,

           Firstname,

           Lastname,

           Address,

           FI_Flag,

           Branch_Code_Open

      FROM

      [Cust Table.xlsx]

      (ooxml, embedded labels, table is Sheet1);

       

       

      LOAD '024' AS Organization_Id,

           '14034' AS BLS_Amount_Type,

           '116002' AS Reporting_Group_Id,

           Cust_Number,

           Product_Code,

           ApplyMap('BLS_LNSMap',Product_Code) as BLS_Item,

           Amount_In_Country_Reporting,

           Unearned_Amount,

           Unrealized_Amount,

           Amount_In_Country_Reporting - Unearned_Amount - Unrealized_Amount AS Amount,

           Load_Source,

           Snapshot_Date

      FROM

      [Loan Table.xlsx]

      (ooxml, embedded labels, table is Sheet1);