Home > Software > QlikView
Interview Questions   Tutorials   Discussions   Programs   Videos   

QlikView - What is mapping load and apply map()?

asked SRVMTrainings November 19, 2014 01:24 AM  

What is mapping load and apply map()?


2 Answers

answered By   0  

applymap: it is used to add the fields to our table with the help of other table . It is used as joins . The main diff between join and applymap is : If we have to add multiple fields i prefer join if we have to add one or two fields i prefer applymap

Mapping: The mapping prefix is used to create a mapping table that can be used for e.g. replacing field values and field names during the script run.

   add comment

answered By SRVMTrainings   0  
Mapping Load: The mapping prefix is used on a load or select statement to create a mapping table, these tables are different from other tables. They will be stored in separate area of memory and used as mapping tables during script execution. After execution they will automatically drop.
Ex. Mapping (Load Statement/Select Statement)
Apply Map: used for mapping data from one source to another at load time.
Ex. Applymap(‘Mapname’, expr,[default expr])
   add comment

Your answer

Join with account you already have



 Write A Tutorials
Online-Classroom Classes

  1 person following this question

  3 people following this tag

  Question tags

qlikview × 1

Asked 2 years and 4 months ago ago
Number of Views -1931
Number of Answers -2
Last updated
1 year and 11 months ago ago

Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!