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....