Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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...
Need Help
Jai-Rathinavel's avatar
Jai-Rathinavel
Super User
1 year ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

     

     

    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's avatar
      Jai-Rathinavel
      Super User
      1 year ago

      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.