topic MapSubstring() strange behavior or bug? in QlikView

MapSubstring() strange behavior or bug?

rbecher — Tue, 26 May 2009 15:03:59 GMT

Hi all,

we're using MapSubstring() to convert strings into phonetical codes. During our tests we got some strange results. Here is a sample code:

daten:
LOAD * INLINE [
var
Wikipedia
da
dy
dd
dkd
dz
];

testMap1:
mapping LOAD * INLINE [
x, y
d, 1
dy, 2
dz, 3
];

test1:
load var as var1, '#'&MapSubString('testMap1',lower(var)) as test1 resident daten;

testMap2:
mapping LOAD * INLINE [
x, y
d, 1
dy, 2
dz, 3
dh, 4
];

test2:
load var as var2, '#'&MapSubString('testMap2',lower(var)) as test2 resident daten;

The second map don't works right (see attached app). The additional entry "dh" creates the problem. I wonder why.

Any suggestions?

Ralf

MapSubstring() strange behavior or bug?

Tue, 26 May 2009 18:07:48 GMT

Ralf,

I think its because testMap1 and testMap2 have the same structure (both consist of fields x and y). Try changing 'x' to 'xx' and 'y' to 'yy' in testMap2.

Regards,

Gordon

MapSubstring() strange behavior or bug?

rbecher — Tue, 26 May 2009 18:13:14 GMT

Gordon,

this is not the problem. We tried it before. Even if only the second mapping stands alone (no first mapping exists) the problem is there.

Ralf

MapSubstring() strange behavior or bug?

johnw — Sat, 06 Jun 2009 03:48:11 GMT

It definitely looks like a bug, but I can see what's happening. It appears that specifying a map for D, DH and DP causes everything between DH and DP to lose the D mapping. This can be clearly seen in the attached example. It's as if QlikView has internally decided that DH and DP define a range, rather than just being specific values. It's like it's doing this:

if character is D

remove D

if character between H and P

if character = H

remove H

insert DH map charcters

else

if character = P

remove P

insert DP map characters

end if

else

insert D map characters

end if

Which is completely wrong. Would you like to report this to QlikView? Would you like me to?