topic Re: Script Load SQL Joining in QlikView

Script Load SQL Joining

Thu, 11 Dec 2014 07:56:23 GMT

How can I join two Oracle tables on Script load

Re: Script Load SQL Joining

Peter_Cammaert — Thu, 11 Dec 2014 08:02:46 GMT

Identical post to the one here: Script Load SQL Joining

Please do not post your questions twice in different forums. Thank you.

Re: Script Load SQL Joining

Thu, 11 Dec 2014 08:03:20 GMT

Hi,

Load 2 tables from oracle and write join (it depends what kind of join u wanna write , u can use left join , Right join, inner join) .....

Ex:

emp:

sql

select * form table1;

left join(emp)

sql

select * from table 2 ;

Re: Script Load SQL Joining

its_anandrjs — Thu, 11 Dec 2014 08:05:34 GMT

Hi,

Write this way

Rep_Details:
LOAD
`Rep_Id`;
SQL SELECT *
FROM Data;

Join

Rep_Category:
LOAD `Rep_Id`,
`Rep_Name`,
`Category_Desc`;
SQL SELECT *
FROM `Rep_Category`;

Please open single thread for the same question

Script Load SQL Joining

Regards

Anand

Re: Script Load SQL Joining

Thu, 11 Dec 2014 11:16:53 GMT

Thanks its working.

Regards,

Naveed

Re: Script Load SQL Joining

Fri, 12 Dec 2014 06:49:47 GMT

Hi Naveed ,

Please close the thread .......