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

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

ananyaghosh — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: need Apply map help

Anil_Babu_Samineni — Wed, 05 Jul 2017 10:28:46 GMT

You are doing 2 mapping table that means, It will disable and it may assign to next table. Can you do Left join for third table with out using Mapping for second table

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

ananyaghosh — Wed, 05 Jul 2017 10:32:24 GMT

Hi,

I have solved the first issue and problem statement has been changed. Please response to the current one.

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

Anil_Babu_Samineni — Wed, 05 Jul 2017 10:36:15 GMT

Will you able to share full script?

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

jonathandienst — Wed, 05 Jul 2017 10:39:05 GMT

Applymap is like a vlookup in Excel. It looks up the value provided - the key name in the ApplyMap statement is not relevant, only the value. The second parameter in the Applymap can be any expression that returns an appropriate value for the lookup.

You have not provided enough of your script to diagnose the "missing" values. Is the field missing, or are some instances of the field values null?

The more information (and small samples that illustrate the problem) that you provide, the more accurate and helpful answers you will receive.

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

Anonymous — Wed, 05 Jul 2017 10:40:29 GMT

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

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

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

ananyaghosh — Wed, 05 Jul 2017 10:42:42 GMT

hi,

Below is the code:

MAP2:

Mapping

load Distinct

"D_TERRITORY.Terr Key",

[Terr Regn Mgr Last Name]

resident [D_TERRITORY];

[temp]:

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 second table 'temp', show Terr Key, instead of manager Name in the 'Terr Regn Mgr Last Names' column.

Thanks,

Sandip

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

ananyaghosh — Wed, 05 Jul 2017 10:42:51 GMT

hi,

Below is the code:

MAP2:

Mapping

load Distinct

"D_TERRITORY.Terr Key",

[Terr Regn Mgr Last Name]

resident [D_TERRITORY];

[temp]:

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 second table 'temp', show Terr Key, instead of manager Name in the 'Terr Regn Mgr Last Names' column.

Thanks,

Sandip

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

ananyaghosh — Wed, 05 Jul 2017 10:49:25 GMT

ok, then why my second table does not pick up the corresponding values from the Mapping table?

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

Anonymous — Wed, 05 Jul 2017 10:55:19 GMT

I guess because

"F_SALES_TRN_TERR_LIST.Terr Key"

and

"D_TERRITORY.Terr Key"

don't match ...

Perhaps you could provide some sample data as qvd?

Re: need Apply map help

ysj — Fri, 19 Jan 2018 07:25:54 GMT

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

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