• Documentation
  • Workato Blog
  • Product Blog
  • Return to Workato
  • Login
  • Automation Institute
  • Documentation
  • Community Forums
New Topic
Discussions Recipe Building Recipe Building Questions
A

ACL Services Ltd.

started a topic over 4 years ago
Answered

Merge CSV

Hello,


I have two CSV files on Amazon S3, both have same headers. My goal is to


(1) Merge them

(2) Remove any duplicate record


For example

CSV1:
Name, Lunch, Food

Gord, Breakfast, Apple

Dale, Breakfast, Banana

Lucy, Dinner, Steak



CSV2:

Name, Lunch, Food

Lucy, Dinner, Steak

Brian, Lunch, Banana



Merged:
Name, Lunch, Food

Gord, Breakfast, Apple

Dale, Breakfast, Banana

Lucy, Dinner, Steak

Brian, Lunch, Banana


Best Answer
A
Amanda Wong said about 4 years ago

Hi there! You most likely got an answer from other means of support but I wanted to leave an answer here to benefit others. 


This can be easily achieved using the Collection by Workato app. Insert the csv data into Collection and run a simple sql query to obtain unique values in the result set. See this recipe example.

Answer

Amanda Wong

said about 4 years ago

Hi there! You most likely got an answer from other means of support but I wanted to leave an answer here to benefit others. 


This can be easily achieved using the Collection by Workato app. Insert the csv data into Collection and run a simple sql query to obtain unique values in the result set. See this recipe example.


1 person likes this

Amlan

said almost 4 years ago

Is this available for all plans?

Alvin Ee

said almost 4 years ago

The Collections feature is available for users on the Business Plus plan and above. 

Login to post a comment

Still can't find your solution?

Send us a ticket, we will try our best to assist you with your problem

Documentation
Developer's Library
Tutorials
eBooks
Product Hour
Product Blog
Workato Blog
Product updates
Customer Stories
© Workato 2022   Privacy   Terms   +1 (844) 469-6752
  • Documentation
  • Workato Blog
  • Product Blog
  • Solutions
  • Forums
  • Tickets
  • Log in
  • Return to Workato
Topic views count