How to add Columns to a csv file?

[_AnonymousUser]

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?

[Anonymous]

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

[Anonymous]

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

[_AnonymousUser]

Will you put up some screenshots of it???

[_AnonymousUser]

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

Uploaded with ImageShack.us

[_AnonymousUser]

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

[Anonymous]

@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.

[_AnonymousUser]

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

[Anonymous]

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

[Anonymous]

@esabot. It's working. Thx