Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

how do i join to tables from 2 schemas

Hi

I have to join 2 tables from different schema ..

the join condition is on the product_key ,by reloading the below statement i get oledb error . I think this is something i have to do using resident , could any one please assit me with it..



SQL

SELECT *

FROM "schema1"."table1" join "schema2"."table2" on

"schema1"."table1".PROD_KEY = "schema2"."table2".PROD_KEY ;





3 Replies
deepakk
Partner - Specialist III
Partner - Specialist III

HI Ramya,

Are you pulling data from Oracle ?

Try to select few fields in the select statement and check if it is fine or not.

In case of oracle you might have convert the date fields to a particular format. eg: to_Char(Datefield, 'YYYY-MM-DD').

Try out the above cases and let us know if it doesn't work.

Anonymous
Not applicable
Author

Hi Deepak

Pulling specific coloumn actually worked without any errors, but the result set of data is not the whole set of data i am looking for in the application , i tried to use all joins i can.

Could you please let me know how are the tables actually joined in qlikview?

For eg:

I have 3 different table linked to each other with keys

table A linked to table b with key 1

table b is linked to table c with key 2

table c is linked to table A with key 3 ,

I just used a normal sql join statement , but not sure if thats the right way to do in qlikview, because when i see object explorer mapping before writing the join sql statement , all the tables look joined to each other with Syn1,Syn2 and so on....

Could you please direct me to the right way of doing this..

Thank you...

deepakk
Partner - Specialist III
Partner - Specialist III

hi Ramya,

In QV joining of tables occurs based on the Name of the field.

For eg if you have ID from one table and ID from other it will automatically links the two table.

eg:

Select A, B , C from TEST;

Select A, D,E from Test1.

In the above Case the joining will happen on the A field (its Case sensitive hence small a and Capital will not link).

In Same Case if you have same name from both the tables and you dont want to link then use a alais for one of the field

Eg:

Select A, B, C, X from Test;

Select A, D, E, X as XY from Test1;

In the above case I didnt wanted to join the tables based on X hence I changed its name to XY.

I hope this helps.