topic Re: Joins in QlikView

Joins

Wed, 13 Mar 2013 20:42:30 GMT

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

er_mohit — Wed, 13 Mar 2013 20:46:05 GMT

using Ctrl + F

Re: Joins

Wed, 13 Mar 2013 20:51:35 GMT

Ctrl + F is just a find and replace

Re: Joins

CELAMBARASAN — Wed, 13 Mar 2013 21:38:19 GMT

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

rwunderlich — Thu, 14 Mar 2013 00:31:32 GMT

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