Discussions

Expand all | Collapse all

Table to Table Import, removing duplicates

  • 1.  Table to Table Import, removing duplicates

    Posted 06-14-2018 19:17
    I have a table of orders. Each order has an address, and customer number.

    There are multiple records in the table where the customer number and address are the same (the only difference is item description)

    I wanted to do a table to table import, and remove duplicates.

    Meaning I only want to import unique customer number and address. 


    Is there a way to remove the duplicates and do a table to table import?


  • 2.  RE: Table to Table Import, removing duplicates

    Posted 06-14-2018 19:42

    If you create the new table with the Customer Number and Address fields

    then change the Customer Number to the Key Field before importing the records the key field will load the first customer record only. Hope this helps

     



  • 3.  RE: Table to Table Import, removing duplicates

    Posted 06-14-2018 20:54
    Hi Eric, I think the answer is going to be a little more complicated than this. I�m pretty sure that if you try to import data with duplicate data in the key field it will abort the import.

    I do have an idea of how to do it though and I will post back when I get a chance. Hi Eric, I think the answer is going to be a little more complicated than this. I�m pretty sure that if you try to import data with duplicate data in the key field it will abort the import.

    I do have an idea of how to do it though and I will post back when I get a chance.


  • 4.  RE: Table to Table Import, removing duplicates

    Posted 06-15-2018 14:42
    Agreed, the import is aborted when you try to bring in the duplicate data. Thanks for any help you can provide on this


  • 5.  RE: Table to Table Import, removing duplicates

    Posted 06-15-2018 16:02
    Ashley
    You can make a new table where the Key field is the Customer Number.

    Then make a Summary report to group by Customer number and Customer name and then use the more button to copy these to a another table.

    The ones which already exists will just overwrite the existing ones with no change.

    If you then need to eliminate duplicates in some other table, you can make a relationship to this unique customer table and make a summary minimum of the [Record ID#] field.  Then look that up down to the details table and call it [Record ID# of the first record]

    Then the duplicates would be the once where the [Record ID#] is not equal to the [Record ID# of the first record] and the [Record ID# of the first record] is > 0.


  • 6.  RE: Table to Table Import, removing duplicates

    Posted 06-19-2018 18:31
    This helps tremendously. Is there a way to automate copying a report to another table?


  • 7.  RE: Table to Table Import, removing duplicates

    Posted 07-01-2018 23:06
    I have the same Issue 

    Did you figure out anything?


  • 8.  RE: Table to Table Import, removing duplicates

    Posted 07-01-2018 23:08
    An Action can copy a Table report to another table, but not a Summary report.


  • 9.  RE: Table to Table Import, removing duplicates

    Posted 07-01-2018 23:13
    The issue is you can not make more than 6 rows on a summary report 

    So I have to it 2 or more times to transfer from one table to another 

    I wish there is a way 


  • 10.  RE: Table to Table Import, removing duplicates

    Top
    Contributor
    Posted 07-01-2018 23:27
    AA>Is there a way to automate copying a report to another table?
    SK>The issue is you can not make more than 6 rows on a summary report 

    It can easily be done with script. The only real issue is identifying the source report and target table. You can summarize the data as part of the script and again the only real issue is which fields to summarize and how. Scripts don't have limitations but hard coded features are nothing but limitations.


  • 11.  RE: Table to Table Import, removing duplicates

    Posted 07-01-2018 23:29
    Sam,
    I suggest that you make a new post and describe your issue as opposed to adding onto an other thread where it is not really explained what you need.


  • 12.  RE: Table to Table Import, removing duplicates

    Posted 07-01-2018 23:30
    OK Thanks mark will do