my table is duplicating values wrong..

[Nemo1]

hello, 

so I have the following:

I have a table, with 4 columns... 

Client (this dimension is made of different datasets, from different stores, that go through a mapping to i have the names of the clients all standarized)

store (each dataset is from a different store)

opening certification (comes from a different dataset, with two columns, client (which goes through the mapping) and certification which is a YES or

... some clients are not even in this dataset so i get a "-"

sum(sales), (each of the store datasets have a "sales" column"..... 

the clients are either certificate for ALL of the stores or not certificate for ALL of them, or do not even appear and I get a "-"

It should not happen, that the same client is certificated for one store, but not for other... 

however, i get that.. 

i also get this:

Client	Store	Certification	sales
Coca	1	-	5
Coca	1	no	7

when i should get it like this:

Client	Store	Certification	sales
Coca	1	no	12

what could i be doing wrong?

thanks

[pravinboniface]

@Nemo1 I wonder if you have some null values for the keys you are joining the datasets on.  I would check the Client and Store columns for nulls.

If that does not help, can you please share more information on the datasets you are joining.