Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

sql and qlikview join

Hi,

I need to implement replica of BO report in Qlikview which has below SQL, I have loaded the two tables , can I link two tables in Qlikview by renaming column same as join condition mentioned in SQL query

Select col1,col2

From table1,table2

where

table1.col1=table2.col2

17 Replies
Not applicable
Author

kumarkp412
Creator II
Creator II

Hi Vibhu,

can you elaborate your question?

Based on my understanding ,

create a script like this.

table1:

load

--

col1 as col

--;

select

--

--

from-----

left join(table1)

load

--

col2 as col

--;

select

--

--

from--

maxgro
MVP
MVP

Rename (alias) col2 to col1.


Table1:

select

    col1,

    ....

Table2:

select

    col2 as col1       

    .....

After the reload, in the table viewer (ctrl-t) you should have the 2 tables associated by col1

jpenuliar
Partner - Specialist III
Partner - Specialist III

jpenuliar
Partner - Specialist III
Partner - Specialist III

its also possible to use SQL joins(and other SQL stuffs) within Qlikview Script

vishsaggi
Champion III
Champion III

Hello Vibhu,

This is a duplicate thread. Please close one of them so that other people can benefit if your query is answered. Your same question thread is : shared in rodrigo msg above ?

Thanks,
V.

Not applicable
Author

Hi,

I observed above approach is not giving correct result

Not applicable
Author

Hi,

I have closed other thread

Not applicable
Author

Can you suggest options to do that please