Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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