How to add Columns to a csv file?

One Star

How to add Columns to a csv file?

Hi,
i'm new to Talend Open Studio and i got the following issue.

The csv file consist of 3 Columns:
Field1|Field2|Field3
A1 |B1 |C1
... |... |...
An |Bn |Cn
now i want to add 3 Columns with the following properties:
Field4 should contain a constant value
Field5 should contain of field2 + field3 (B-C)
Field6 should contain of field3 + field2 (C-B)
how can i realise this issue?
One Star

Re: How to add Columns to a csv file?

Open in a spreadsheet, add the columns and Save As CSV
Community Manager

Re: How to add Columns to a csv file?

Hi
tSplitRow or tMap component can fit your need. I suggest you to learn these two components, especially tMap component, it is a very important component and you will use it often in your job.
Let me know if you have any questions!
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: How to add Columns to a csv file?

Will you put up some screenshots of it???
Highlighted
One Star

Re: How to add Columns to a csv file?

Hi,
first i want to thank you for your quick response.
Screenshot:

Uploaded with ImageShack.us
One Star

Re: How to add Columns to a csv file?

Hi,
i've resolved the issue i got thx for your effort.

Community Manager

Re: How to add Columns to a csv file?

@memotec10: please register to become a member (instead of "guest") of Talend Community, if you want to get the "image upload" feature.
For registered users, I realize the image upload feature is only available when clickin on "post reply" (not through the quick post")
This would be easier for you and more convenient for other users than pasting urls. Smiley Happy
One Star

Re: How to add Columns to a csv file?

@esabot: I've been registred by talend.com since yesterday, but I can't login to talendforge.
Community Manager

Re: How to add Columns to a csv file?

I have notified your issue to our IT. I'll get back to you as soon as I can, sorry about this.
One Star

Re: How to add Columns to a csv file?

@esabot. It's working. Thx Smiley Happy
Community Manager

Re: How to add Columns to a csv file?

Welcome to the Talend Community!

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch