topic Apply Map in preceeding load in QlikView

Apply Map in preceeding load

Fri, 20 Feb 2015 01:04:43 GMT

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

;

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

Re: Apply Map in preceeding load

sunny_talwar — Fri, 20 Feb 2015 03:28:46 GMT

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

ApplyMap(.....) as D

;

SQL SELECT * FROM EMPLOYEES;

STORE Employee in employee.qvd

Best,