4 Replies Latest reply: Mar 13, 2013 8:31 PM by Rob Wunderlich RSS

    Joins

      Hi.  I wanted to know if there was a way I could just quickly hit some kind of button or something to clear all the joins that Qlikview created?  I am working with tables that have the same names for fields but they are not supposed to be joined; the data is different.  Instead of correcting each join is there a quick way to eliminate all the joins and then establish them myself?  Thank you.

        • Re: Joins
          Mohit Sharma

          using Ctrl + F

          • Re: Joins
            Celambarasan Adhimulam

            Hi,

            Qlikview has feature to join the fields with same name. You won't stop that which is the speciality of Qlikview.

            What you need to do is rename the fields which should not join.

            • Re: Joins
              Rob Wunderlich

              The join will happen automatically when the field name is the same. You can't change that behavior. You can rename the fields so they don't link up.

               

              A quick way to do this is the QUALIFY script statement.

               

              QUALIFY *;

               

              That will preprend the table name to each field name giving you unique field names for each table. You follow the above QUALIFY with an UNQUALIFY to name the fields that you do want to link.

               

              For example:

               

              QUALIFY *;

              UNQUALIFY CustomerID, ProductIID;

               

              Orders:

              SQL SELECT * FROM Orders;

              Customers:

              SQL SELECT * FROM Customers;

              Products:

              SQL SELECT * FROM Products;

               

              -Rob