Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have 2 connections in my Qlikview dashboard. 1 table called orders with an id field and other table with customer information from another data source pulling field in.
i want to join them on the id field where it only pulls data from the customer table if the id is present in the orders table, i know you can alais the field to give them a full join but that is not what i want.
any help appreciated.
thanks
laura
You could do something like this:
Table1:
LOAD *;
SELECT <your query 1>;
JOIN (Table1)
LOAD * WHERE EXISTS (id);
SELECT * FROM Table2;
However, that will still fetch all the records from Table2. There's no easy way around it I'm afraid (or at least one that doesn't break easily).
the tables are from 2 different databases. so it looks like
Connect to database a
Table1:
LOAD *;
SELECT <your query 1>;
Connect to database
LOAD *;
SELECT <your query 2>;
the tables are from 2 different databases. so it looks like
Connect to database a
Table1:
LOAD *;
SELECT <your query 1>;
Connect to database
LOAD *;
SELECT <your query 2>;
same difference
Hi it doesn't work though.
where should i be putting the left join?
to be more specific it looks like
ODBC Connect xxx
orders:
load aaa, bbb , cccc;
sql select aaa, bbb,ccc
from abc
odbc connect xxxx
load aaa, dddd , eeee;
sql select aaa, ddd,ceee
from dbe
i want to join aaa in orders to aaa in the other table, i want want aaa in the other table where there is an aaa which matches in orders?
to be more specific it looks like
ODBC Connect xxx
orders:
load aaa, bbb , cccc;
sql select aaa, bbb,ccc
from abc
odbc connect xxxx
load aaa, dddd , eeee;
sql select aaa, ddd,ceee
from dbe
i want to join aaa in orders to aaa in the other table, i want want aaa in the other table where there is an aaa which matches in orders?