Discussion board where members can get started with QlikView.
Hello, i want join two tables with the same fields but i have duplicated values. My tables are like this :
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 ?
Go to Solution.
LOAD DISTINCT article,