Help on Duplicate Values

[tksnota]

Hi,

I created a relationship between several tables by appending their projects. I'd made them all Uppercase, Trim, Clean& Remove Duplicates+Errors+Empty.

However the amount in dc are duplicated for every value net and proposal numbers.

Is it possible to only show not duplicated and unique values because the total of had quadrupled?

Is the Table Union might also be causing the problem? 

Thanks...tksnota...

[Jai-Rathinavel]

@tksnota Follow a star schema by having Fact and Dimension tables, Fact table values would be ID, Amount, Sales etc.. any number values. Dimension table would have values like project, Project_new_wip. 

Thanks,

Jai

[tksnota]

Hi,

It worked to some extent but still the issue persist like when the Proposal Nos are different then the cost was duplicated like what happened to project no: 2024-248 as shown

[Jai-Rathinavel]

@tksnota You would need to separate out Project No and Current cost column in a different table and remove duplicates. But this issue can be avoided by following the modelling best practices. Always expand the text fields after merging queries not the aggregated or number fields since it will inflate the totals.