Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ;
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.
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...
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.