sql and qlikview join

[#1]

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

[#2]

Implement sql in script editor

[kumarkp412]

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]

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]

Have a look here:

Understanding Join, Keep and Concatenate

[jpenuliar]

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

[vishsaggi]

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.

[#8]

Hi,

I observed above approach is not giving correct result

[#9]

Hi,

I have closed other thread

[#10]

Can you suggest options to do that please