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?
10 REPLIES
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???
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!