8 Replies Latest reply: Apr 6, 2015 4:03 AM by Christopher Marlow RSS

    Pick Match ApplyMap combined

    Wande Sulu

      Hi all,

       

      Please kindly advise on the best approach.

       

      I have a mapping table in an Excel spreadsheet that will be loaded into Qlikview as part of my data model.

       

      If a condition is meant, I want the name to change from Original Name to New Name

       

      Original NameNew Name
      JohnNew John
      PaulNew Paul
      JakeNew Jake
      TomNew Tom
      TimNew Tim
      PeterNew Peter

       

       

      Please how can I replace Original Name with New Name in a script. For examle, if a condition is meant I want the name to change from i.e. John to New John.

       

      I was explore Pick(Match(ApplyMap.....)

       

      Also, can you kindly describe how the Pick(Match( function works?

       

      Regards