Skip to main content
Solved

Creating a report that is returning duplicate records


Can someone help me with what I’m doing wrong here please?

I created a report joining 2 files to retrieve Customer #, Customer Name, Email address, and Date the Customer # was created.  Joining the 2 files to include the Email address returns the same line multiple times for some customers, while other customers only return a single record.

What can I do to prevent the duplicate records?

 

 

Best answer by yhartman

When joining two tables, you will get duplicates if one of the tables has duplicates. For instance, one customer can have multiple contacts, so you will get numerous results when joining a customer with various contacts. 

If your goal is only to show a single record per customer with the default contact, you can join the table as follows defContactID Equal contactID.

I hope this helps.

 

View original
Did this topic help you find an answer to your question?

2 replies

Forum|alt.badge.img+3
  • Jr Varsity I
  • 61 replies
  • Answer
  • April 10, 2022

When joining two tables, you will get duplicates if one of the tables has duplicates. For instance, one customer can have multiple contacts, so you will get numerous results when joining a customer with various contacts. 

If your goal is only to show a single record per customer with the default contact, you can join the table as follows defContactID Equal contactID.

I hope this helps.

 


  • Author
  • Freshman I
  • 1 reply
  • April 10, 2022

Thank you SOOOO much!  That completely fixed my issue.  

I really appreciate it!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings