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
almost 2 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
almost 2 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 2 years ago
Is this available for all plans?
Alvin Ee
said
almost 2 years ago
The Collections feature is available for users on the Business Plus plan and above.
ACL Services Ltd.
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
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.
Amanda Wong
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
Is this available for all plans?
Alvin Ee
The Collections feature is available for users on the Business Plus plan and above.