3 Replies Latest reply: Oct 17, 2018 6:31 AM by Ivan Bozov RSS

    & symbol in qlik

    xxxxx yyyyy

      I have 2  field From and TO.

      From   TO

      Del-    Ban

      Ban-   Del

      Chn-  Bom

       

      i want new filed like sector

       

      From   TO         sector

      Del-    Ban       Del-Ban

      Ban-   Del        Ban-Del

      Chn-  Bom       Chn-Bom..

       

      Script:

      LOAD

          "Flight No",

          "From",

          "TO",

          STD,

          STA,

          "From" '&'-'&' "TO" as Sector

       

      It's not working