4 Replies Latest reply: Jun 19, 2014 12:13 PM by Massimo Grossi RSS

    JOIN LIKE

    Przemysław Wojda

      Hi there,

       

      do you have an idea how to join tables on like operator? I've got a full address table and a zip codes with regions table. I need to match address with a region on fly like here:

       

      FullAddress:

      Berliner Straße 11, 04105 Leipzig

      Berliner Straße 9, 80805 München

       

      ZipCodesRegions:

      04105, Saxony

      80805, Bavaria

       

      Final:

      Berliner Straße 11, 04105 Leipzig, Saxony

      Berliner Straße 9, 80805 München, Bavaria

       

      Regards,

      Przemek

        • Re: JOIN LIKE
          Alessandro Saccone

          There are 2 main ways (using Qlik functionalities):

           

          1) join the tables and filter the resulting one with a where condition with wildmatch function (it works as a like but with fields on the same table)

          2) Extract the address code as a new field in both the tables and then join them on this new field.

           

          for example you could extract the carachters after comma in the first table and before comma in the second

           

          Let me know

          • Re: JOIN LIKE
            Prashant Sangle

            Hi,

             

            In Qlikview You can use

            Wildmatch() to achieve this

             

             

            Regards,

            • Re: JOIN LIKE
              Massimo Grossi

              MapZipCodesRegions:

              Mapping load *inline [

              from,to

              04105, Saxony

              80805, Bavaria

              ];

               

              FullAddress:

              load *, MapSubString('MapZipCodesRegions',a) as newfield;

              load * inline [

              a

              "Berliner Straße 11, 04105 Leipzig"

              "Berliner Straße 9, 80805 München"

              ];