Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
using Ctrl + F
Ctrl + F is just a find and replace
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.
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