How to show the different mapping field in the same column

Sun, 04 Dec 2011 19:17:02 GMT

Hello,

I'm trying to map 2 tables to the same code.

--------------------------

BLS_LNSMap:

MAPPING

LOAD Prod_LNS_Code,

BLS_Item_LNS

FROM

balancesheetitemMap_LOAN.xlsx

(ooxml, embedded labels, table is Sheet1);

Map BLS_LNS_Show using BLS_LNSMap;

BLS_GGLMap:

MAPPING

LOAD GGL_Code,

BLS_Item_GGL

FROM

balancesheetitemMap_GGL.xlsx

(ooxml, embedded labels, table is Sheet1);

Map BLS_GGL_Show using BLS_GGLMap;

-------------------------------

By the way, I'd like to show both "BLS_LNS_Show" and "BLS_GGL_Show" in the same column on QV table with below LOAD statement:

-----------------------------

LOAD GL_Code,

GL_Code AS BLS_GGL_Show,

Amount_in_Book_Currency,

Amount_in_Country_Reporting_Currency,

Snapshot_Date

FROM

[GGL Table.xlsx]

(ooxml, embedded labels, table is Sheet1)

LOAD Cust_Number,

Product_Code,

Product_Code AS BLS_GGL_Show,

Part_Code,

Amount_In_Country_Reporting,

Unearned_Amount,

Unrealized_Amount,

Loan_Date

FROM

[Loan Table.xlsx]

(ooxml, embedded labels, table is Sheet1);

---------------------------------

How could I do that? Due to the fact that"BLS_LNS_Show" and "BLS_GGL_Show" is the same key, and

"Amount_in_Country_Reporting_Currency" and "Amount_In_Country_Reporting" should be shown on the same column.

Anybody can give me the solution?

I would be very much appreciated and thankful for your help....

topic How to show the different mapping field in the same column in QlikView

How to show the different mapping field in the same column