Is mapping with QVD still a problem?

[#1]

Hi

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?

[eduardo_sommer]

Hi Mikael

Can you share the script?

Eduardo

[maxgro]

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

];

[#4]

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);

[maxgro · Accepted solution]

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],

[#6]

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