topic When to use mapping? in QlikView

When to use mapping?

Mon, 06 Feb 2012 14:40:14 GMT

Hi

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

Can someone give me som exampels?

/Thanks!

When to use mapping?

m_woolf — Mon, 06 Feb 2012 22:03:54 GMT

Here is an example from help:

mapping load * inline [

x,y

US,USA

U.S.,USA

America,USA ];

When to use mapping?

Tue, 07 Feb 2012 04:07:51 GMT

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