Contact details deduplicate

At a glance

The community member is using the "contact details merge and deduplicate" tool by Lukas UT, but is facing an issue where the exported results are not in the same order as the original input. This means the community member has to manually update their sheet, which is time-consuming. The other community members suggest that datasets are usually not ordered, and the community member could try writing a script to order the data or use the sorting capabilities of their spreadsheet software. They also mention another tool that has an option to keep the original order while deduplicating, but it is more complicated to use and requires setting up a custom transformation function. There is no explicitly marked answer in the comments.

JJackoM8

Hello im using the contact details merge and deduplicate by lukas ut the problem im having is when i export the results the are mostly in a different order than what i inputted meaning i have to go through manually one by one updating my sheet taking a ton of time instead of being able to just copy and paste the columns is there any way to fix this?

Attachments

2 comments

MMarco

Hello! I'm not sure to understand your use case: why are you going to merge the "merge and deduplicate" output with the initial data? Is some data missing from the final dataset?

Usually, datasets are not ordered, and this Actor makes no exception: if you want to order the data, you would probably want to write a script to do it, or use the sorting capability of Google Sheets, Microsoft Excel, and similar.

You could also take a look at this Actor, which has an option to keep the original order while deduplicating, but is more complicated to use and requires to setup a custom transformation function.

PPepa J

Hi If you have suggestion for feature/improvement to the specific Actor please go to the Actor detail, select Issues tab and write your suggestions there.

Add a reply

Apify Discord Mirror

Contact details deduplicate