Forum Discussion
Help on Duplicate Values
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 duplica...
Anonymous 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
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
Anonymous 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.