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

    Pick Match ApplyMap combined

      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?