2 Replies Latest reply: Feb 6, 2012 11:07 PM by rathish kumar RSS

    When to use mapping?

    Göran Hofstedt

      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 w

          Here is an example from help:

           

          mapping load * inline [

          x,y

          US,USA

          U.S.,USA

          America,USA ];

            • When to use mapping?

              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