Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

When to use mapping?

Hi

A simple question but when and for what purpos does the mapping function have?

Can someone give me som exampels?

/Thanks!

2 Replies
m_woolf
Master II
Master II

Here is an example from help:

mapping load * inline [

x,y

US,USA

U.S.,USA

America,USA ];

Not applicable
Author

Hi,

A mapping table consists of two columns, the fist containing comparison values and the second containing the desired mapping values. Mapping tables will be stored temporarily in the memory and dropped automatically, after script execution. The syntax is:

mapping ( loadstatement |selectstatement )

Examples:

mapping load * from x.csv

mapping select a, b from map1

map1:

mapping load * inline [

x,y

US,USA

U.S.,USA

America,USA ];

Thanks,

Rathish