Home > Software > QlikView
Interview Questions   Tutorials   Discussions   Programs   Videos   

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




2753
views
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.

flag   
   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])
flag   
   add comment

Your answer

Join with account you already have

FF

Preview

 Write A Tutorials
Online-Classroom Classes
www.writeabc.com


  1 person following this question

  3 people following this tag

  Question tags

qlikview × 1

Asked 3 years and 5 months ago ago
Number of Views -2753
Number of Answers -2
Last updated
3 years and 24 days 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!

Alert