Dups management

[Anonymous]

I want to know how it works Qlickview in certain situations:

I have sales tables:

sales:

product region sales

P1       R1     100

P2       R1      200

P3       R2      300

and product table:

product:

product category

P1       C1

P2       C1

P2       C2

P3       C3

I have a duplicate by product in P2 ( 2 rows)

Qlickview  using AQL will join thw two tables by product, that will generate a dup in sales in P2 row?

It I make a SQL join it will be a dup, I want to know how Qlickview work in that case...

Thanks

[simospa]

Sorry, I don't understand which is the criteria you are using to choose C1 raither than C2 category... 😞

S.

[anbu1984 · Accepted solution]

LOAD product,MaxString(category) As category Group By product;
Load * Inline [
product,category
P1,C1
P2,C1
P2,C2
P3,C3 ];