Combine data if duplicate field?

View: New views
3 Messages — Rating Filter:   Alert me  

Combine data if duplicate field?

by WylieInc :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

 Hi all,
I have a combined Excel file of a list of email addresses with a column containing a number identifier (where the list was exported from).
When there is a duplicate email I would like to combine the numbers.

How it is:
FirstName | Lastname | Company     | Email            | SenderID
John           Smith          xyz              js@xyz.com       2
John           Smith          xyz              js@xyz.com       3

What I am looking for:
FirstName | Lastname | Company     | Email            | SenderID
John           Smith          xyz              js@xyz.com       23

Ive searched for the utility to do this, but cant seem to find it.
I could go back to the initial lists before they were merged.
This is urgent.
Thanks much!
Wylie

Re: Combine data if duplicate field?

by Will L <Nabble> :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Thanks for posting the problem, but right now DigDB cannot do it. This is a feature that has been suggested by several people, so hopefully in the next release this feature will be added.

Re: Combine data if duplicate field?

by AndrewIIIrd :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Yes - this would be a popular feature to add onto future editions.
LightInTheBox - Buy quality products at wholesale price!