topic Re: ApplyMap issue? in QlikView

ApplyMap issue?

MarcoWedel — Thu, 17 Apr 2014 23:13:27 GMT

Hi community,

creating a script to solve thread 114112, I experienced an issue with the ApplyMap function:

FieldMap:  
Mapping LOAD * Inline [
0, <none>
1, COUNTRY  
2, YEAR  
3, BRAND  
4, Model  
5, Contidion  
6, Delivered  
];  

tabOutput:  
Generic LOAD  
  %RecordID,  
  ApplyMap('FieldMap', IterNo()),  
  SubField(SubSTR, '|', IterNo())  
While IterNo() <= SubStringCount(SubSTR, '|')+1;  
LOAD  
  AutoNumberHash128(COUNTR, SubSTR) as %RecordID,  
  COUNTR&'|'&SubSTR as SubSTR  
Where Len(SubSTR)>0;  
LOAD COUNTRY as COUNTR, SubField(STR, '~~') as SubSTR  
FROM [http://community.qlik.com/servlet/JiveServlet/download/507618-101744/Sample%20file%20for%20test.xlsx]  
(ooxml, embedded labels, table is INPUT);

The ApplyMap didn't work for value 1 (COUNTRY) unless I added a value 0 in the mapping load.

(To reproduce just delete row "0, <none>" in the mapping load)

Any ideas why ApplyMap behaves like this?

thanks

regards

Marco

Re: ApplyMap issue?

Thu, 17 Apr 2014 23:22:15 GMT

Marco,

dont you need field names in inline?

Like:

FieldMap:

Mapping LOAD * Inline [

id, field_name

1, COUNTRY

2, YEAR

3, BRAND

4, Model

5, Contidion

6, Delivered

];

anyway ... nice script

regards

Darek

Re: ApplyMap issue?

MarcoWedel — Fri, 18 Apr 2014 00:08:12 GMT

*FACEPALM*

thanks, Darek

Regards

Marco

Re: ApplyMap issue?

Fri, 18 Apr 2014 07:44:00 GMT

Marco,

most important is, that you, as usual, found solution (using additional row) .......