Qlik Community

Third-Party Qlik Jobs

Area for people to learn more about current Qlik related job postings.

Not applicable

what is mapping load ?wher we use it?

what is mapping load ?wher we use it?

thanks in advance

1 Solution

Accepted Solutions
Not applicable

Re: what is mapping load ?wher we use it?

Hey manoj

Mapping table are used for cleansing of data and ETL process. The MAPPING statement provides an alternative to the JOIN statement when you want to replace a single key value with a value from mapping table. This function allows us to lookup a value from a Mapping table and fetch the  value which has to be retrieved from another table.It is used with the ApplyMap().

Regards

Surbhi Sahu

Bisp Solutions Inc

http://bisptrainings.com

7 Replies
sokkorn_cheav
Honored Contributor

Re: what is mapping load ?wher we use it?

Hi Manoj,

This one should address your question.

Regards,

Sokkorn

Not applicable

Re: what is mapping load ?wher we use it?

Hey manoj

Mapping table are used for cleansing of data and ETL process. The MAPPING statement provides an alternative to the JOIN statement when you want to replace a single key value with a value from mapping table. This function allows us to lookup a value from a Mapping table and fetch the  value which has to be retrieved from another table.It is used with the ApplyMap().

Regards

Surbhi Sahu

Bisp Solutions Inc

http://bisptrainings.com

rustyfishbones
Honored Contributor II

Re: what is mapping load ?wher we use it?

A mapping load is a table used as part of the Applymap function.

A mapping load can only contain 2 fields, and it does not matter the names of the fields

Basically, it works like vlookup function in excel

giakoum
Honored Contributor II

Re: what is mapping load ?wher we use it?

PLEASE STOP POSTING IN THE JOBS GROUP!

THIS HAS BECOME REALLY ANNOYING. PLEASE MOVE ALL THE DISCUSSIONS TO THE NEW TO QLIKVIEW GROUP.

Re: what is mapping load ?wher we use it?

Dear Manor,

Welcome to the Qlik Community!!!

Most of your questions are very straight forward and rather than asking on

Community,  if you try to search old post or questions ,  I am 100% sure that you will definately get at least 10 different post on the same. 

This will save your valuable time.

Not applicable

Re: what is mapping load ?wher we use it?

Hi manoj,

some time we want create new field for two different fields from different tables. that time we can use mapping function

in mapping table maximum and minimum two fields.to implement.

by using apply map statement we can implement mapping table.

ngulliver
Valued Contributor III

Re: what is mapping load ?wher we use it?

Hi, Manoj.

Have you tried looking at the blog:

http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/

Regards,

Neil