Merge, Dedup & Transform Datasets
Pricing
Pay per usage
Merge, Dedup & Transform Datasets
The ultimate dataset processor. Extremely fast merging, deduplications & transformations all in a single run.
0.0 (0)
Pricing
Pay per usage
77
Monthly users
133
Runs succeeded
97%
Response time
27 days
Last modified
3 months ago
Select contact details
Closed
Hello,
Given the (very) large amount of column the contact details output for this run (1,070 columns in total), I'd like only the first 2 Contact Details of each sub-category (e.g. emails/0 + emails/1 ; Facebooks/0 + Facebooks/1, ...).
How exactly can I make this happen please? I've tried in the JSON input, using the Fileds to Load as e.g. 'contactDetails/facebooks/0',, but it wouldn't output any of these.
Happy to hear from you on that, thanks.
Hello,
I can do a small script for you to do this in this actor. Another option would be to join all emails to one column separated by ;, e.g. instead of emails/0 = john@apify.com and emails/1 = peter@apify.com, it would be emails = john@apify.com; peter@apify.com. And it could join any number (you can decide a limit). Would you prefer that or your original idea?
nico_v
Hello Lukáš,
Thank you for the suggestions. It would be great if you could indeed have contactDetails 0 AND 1 in one column for each contactDetails type (e.g. Facebook 0 + Facebook 1 into one column, separated by a comma).
How should I proceed?
Also, I would need this not for this run in partuclar, but anytime (as I plan many different datasets merges).
Thanks for your help !
Hello,
I created a task "Merge Google Maps - Trim to 2 contacts" for you. There is just a simple transform function that cleans the contacts. See the run below. https://console.apify.com/actors/tasks/WyOhdrUQvylK2G1f6/runs/wONYnadbFx2JeWNY3#output
I also added placeId to deduplication fields so you get rid of duplicate places, it goes down to 31053 places now.
Pricing
Pricing model
Pay per usageThis Actor is paid per platform usage. The Actor is free to use, and you only pay for the Apify platform usage.
