Apply Map in preceeding load

[#1]

Hello

I have a table that I am loading in QV via preceding load.

Where should I insert my applymap statement in here

Example:

Employee:

Load

A,

B,

C

;

SQL SELECT * FROM EMPLOYEES;

STORE Employee in employee.qvd

In this code where should the applymap statement be inserted before the sql or before the load statement?

An example of this would help

Thanks

[sunny_talwar]

So you first need to have the mapping load table and then you can use it in your preceding load. I have never tried to do it, but I don't see a reason why it should not work

MappingTable:

Mapping Load

Employee:

Load

A,

B,

C

ApplyMap(.....) as D

;

SQL SELECT * FROM EMPLOYEES;

STORE Employee in employee.qvd

Best,

S