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 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...

 

 

Need Help

3 Replies

  • 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.