topic Re: Loading a mapping which has a custom wildcard inside in QlikView

Loading a mapping which has a custom wildcard inside

Thu, 05 May 2016 16:43:57 GMT

Hi I have a mapping as attached. And the corresponding salesman and region fields in my raw data. I currently have the following load statement :

LOAD

[Salesman],

Subfield( ApplyMap('ATK_map_P2', [Salesman], [Region1] & '|'),'|',1) as Region1_New,

Subfield( ApplyMap('ATK_map_P2', [Salesman], '|' & [Region2]),'|',2) as Region1_New,

Subfield( ApplyMap('ATK_map_P2', [Salesman], '||' & [Region3]),'|',3) as Region1_New,

FROM ....

The twist is however that the percentage signs in the mapping are basically wildcards. So DAVID% in the mapping basically means match against the salesman field in the raw data if it contains the word david.

Is this something possible to script in ?

Re: Loading a mapping which has a custom wildcard inside

sunny_talwar — Thu, 05 May 2016 16:59:10 GMT

May be something along these lines:

MappingTable:

Mapping

LOAD * Inline [

Name, Region

David, %USA%

Rahul, %India%

];

Fact:

LOAD *,

TextBetween(MapSubString('MappingTable', Salesman), '%', '%') as Region;

LOAD * Inline [

Salesman, Sales

David_R_Johnson, 10

David_K_McGrath, 15

Rahul_Gandhi, 20

];

Re: Loading a mapping which has a custom wildcard inside

Thu, 05 May 2016 17:31:21 GMT

Apologies I forgot to add in my mapping table. Should make things clearer.

Re: Loading a mapping which has a custom wildcard inside

Gysbert_Wassenaar — Fri, 06 May 2016 10:28:27 GMT

Perhaps you can use this: mapping with wildcards | Qlikview Cookbook