Merge csv files

Highlighted
One Star

Merge csv files

Hi
I am having a secanario where i need to merge multiple csv files.
For example if i have two csv files named file1.csv and file2.csv which are like below:
File1.csv
date,returns
20150622,234
20150621,123
20150620,56
20150619,23

File2.csv
date,sales
20150623,1234
20150622,33254
20150621,12453
20150620,53456
20150619,22343
i need the output to be like in newfile.csv
date,returns,sales
20150623,null,1234
20150622,234,33254
20150621,123,12453
20150620,56,53456
20150619,23,22343

the date column are common in all the csv files but not must they are same dates in all files.
my output should contain all the dates with the coresponding other column values if available if not insert null if there is no value.
Moderator

Re: Merge csv files

Hi

Here is a response in your another topic. Could you please check it?
https://www.talendforge.org/forum/viewtopic.php?id=44498

Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Introduction to Talend Open Studio for Data Quality

Find out about Talend Open Studio for Data Quality

Watch Now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read