Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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