Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Join tables on QV

Hello, i want join two tables with the same fields but i have duplicated values. My tables are like this :

table1:                                                                        table2:

article, desc, n°commande                                        article, desc, joinedArticle, Grp

8855, fruit, 0205549                                                   8855, fruit AB, 885596, rouleau

                                                                                   8855, fruit, 885595, rouleau

                                                                                   8855, fruit hg, 885585, rouleau

i also want to display values who don't match.

So my question is how to delete duplicated values and keep all my values ?

Tags (4)
1 Solution

Accepted Solutions
hcabrera
New Contributor III

Re: Join tables on QV

Hi,

Try:

DATA:

LOAD article,

          desc,

          n°commande

FROM

Table1

Left Join

LOAD DISTINCT article,

          desc,

          joinedArticle,

         Grp

from

Table 2

1 Reply
hcabrera
New Contributor III

Re: Join tables on QV

Hi,

Try:

DATA:

LOAD article,

          desc,

          n°commande

FROM

Table1

Left Join

LOAD DISTINCT article,

          desc,

          joinedArticle,

         Grp

from

Table 2