When to use mapping?

[#1]

Hi

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

Can someone give me som exampels?

/Thanks!

[m_woolf]

Here is an example from help:

mapping load * inline [

x,y

US,USA

U.S.,USA

America,USA ];

[#3]

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