Is column name need to be same in ApplyMap() and Mapping table?

[ananyaghosh]

Hi,

I am using the below code:-

MAP2:

Mapping

load Distinct

  "D_TERRITORY.Terr Key",

  [Terr Regn Mgr Last Name]

resident [D_TERRITORY];

now my F_SALES_TRN_TERR_LIST table has F_SALES_TRN_TERR_LIST.Terr Key column and I am using the below code on that key:-

LOAD

[Trn Terr List Key],

ApplyMap('MAP2',"F_SALES_TRN_TERR_LIST.Terr Key") as "Terr Regn Mgr Last Names",

ApplyMap('F_SALES_TRN_Temp',"Trn Key") as "Firm Channel Desc"

resident [F_SALES_TRN_TERR_LIST];

now my last table 'Temp Division' does not show "Terr Regn Mgr Last Names". So is that anything is wrong there as because two column name (D_TERRITORY.Terr Key and F_SALES_TRN_TERR_LIST.Terr Key) are different?

[ysj]

the column names of a mapping table are meaningless...

First column is the Key, second column is the lookup value.