Concatenate two fields

[#1]

Hello,

I want to concatenate two columns as below:

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);