merge column csv

Four Stars

merge column csv

Hello,

 

I am new to the software Talend (1 month and a half) and I am opposed to a problem today.
I have 2 csv file and I want them together knowing that they do not have the same schema. (but the same number of lines).
I would like to copy the columns of one for the meters in the other (or a new file).

 

If you have any leads or solutions, I'm interested.

 

Thank you in advance,
Regards,
Fabien.


Accepted Solutions
One Star

Re: merge column csv

Hi

is there a shared key between the 2 csvs that you can join them on? 

 

You can use a TMap to merge these files on that key - so in my example, col1 from the first csv file (row1) is common with colA on the second (row2):

 

Capture1.JPG

 

Hope this helps

 

Mark


All Replies
One Star

Re: merge column csv

Hi

is there a shared key between the 2 csvs that you can join them on? 

 

You can use a TMap to merge these files on that key - so in my example, col1 from the first csv file (row1) is common with colA on the second (row2):

 

Capture1.JPG

 

Hope this helps

 

Mark

Four Stars

Re: merge column csv

Great !
I don't know this fonctionnality, Thank you !

Regards,
Fabien.
IF

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now