topic Re: Is mapping with QVD still a problem? in QlikView

Is mapping with QVD still a problem?

Tue, 24 Jun 2014 18:32:48 GMT

I am trying too practice mapping and I have a case with this QVD file. It does not work, and I can see in this forum that the workaround should be to first load it, and then mapping load - resident.

Is it still like that or is there a special syntax for QVD files today?

Re: Is mapping with QVD still a problem?

eduardo_sommer — Tue, 24 Jun 2014 18:40:53 GMT

Hi Mikael

Can you share the script?

Eduardo

Re: Is mapping with QVD still a problem?

maxgro — Tue, 24 Jun 2014 19:21:30 GMT

this is very simple and it works; could you provide an example or a link to some post with the workaround?

//tablemap:

//load * inline [

//from, to

//1,a

//2,b

//3,c

//];

//STORE tablemap into tablemap.qvd (qvd);

//DROP Table tablemap;

tablemap:

Mapping load * from tablemap.qvd (qvd);

table:

load

field1,field2,ApplyMap('tablemap',field1) as fieldmap;

load * inline [

field1, field2

1,1

2,2

3,3

4,4

5,5

];

Re: Is mapping with QVD still a problem?

Tue, 24 Jun 2014 19:37:07 GMT

It's the data from the QV11 book (p42), I am just playing around. I made it work before with other files, so I guess I forgot something:

[Aircraft Types]:

Mapping LOAD

[%Aircraft Type ID],

[Aircraft Type]

FROM

[..\Data Files\QVD's\Aircraft Types.qvd]

(qvd);

____

[Main Data]:

LOAD ...,

[%Aircraft Type ID],

Applymap ('[Aircraft Types]', '[%Aircraft Type ID]', 'Unknown') As [Aircraft Type],

...,

FROM

[..\Data Files\QVD's\Flight Data.qvd]

(qvd);

Re: Is mapping with QVD still a problem?

maxgro — Tue, 24 Jun 2014 19:51:35 GMT

I think the problem is here

Applymap ('[Aircraft Types]', '[%Aircraft Type ID]', 'Unknown') As [Aircraft Type],

change to

Applymap ('Aircraft Types', [%Aircraft Type ID], 'Unknown') As [Aircraft Type],

Re: Is mapping with QVD still a problem?

Tue, 24 Jun 2014 20:36:34 GMT

Nice spotted, thx Do you have a recall rule for figuring out what is what?