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

Amanda Wong said over 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 over 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.

Amlan

said over 4 years ago

Is this available for all plans?

Alvin Ee

said over 4 years ago

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

Still can't find your solution?

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