Concatenate two fields

Wed, 07 Dec 2011 20:58:36 GMT

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

topic Concatenate two fields in QlikView

Concatenate two fields