9 Replies Latest reply: May 6, 2015 5:21 PM by Eveline van den Heuvel RSS

    Adapting multiple records with underscore

      Dear all,

       

      I have two tables which I would like to link to one another, but one of them contains underscores and the other one does not.

       

      NameAge
      John Doe40
      Peter Parker41
      Jane Doe42

       

      NameWeight
      John_Doe50
      Peter_Parker60
      Jane_Doe70

       

      I prefer not to change them one by one in the code in case new records are added.

      What is the syntax for removing the underscores in the Qlik Sense data load editor?

       

      Thanks for your help.