topic How to add Columns to a csv file? in Talend Studio

How to add Columns to a csv file?

_AnonymousUser — Sat, 16 Nov 2024 12:04:29 GMT

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?

Re: How to add Columns to a csv file?

Anonymous — Wed, 20 Mar 2013 20:59:14 GMT

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

Re: How to add Columns to a csv file?

Anonymous — Thu, 21 Mar 2013 06:11:58 GMT

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

Re: How to add Columns to a csv file?

_AnonymousUser — Thu, 21 Mar 2013 07:59:30 GMT

Will you put up some screenshots of it???

Re: How to add Columns to a csv file?

_AnonymousUser — Thu, 21 Mar 2013 12:18:50 GMT

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

Uploaded with ImageShack.us

Re: How to add Columns to a csv file?

_AnonymousUser — Thu, 21 Mar 2013 14:05:31 GMT

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

Re: How to add Columns to a csv file?

Anonymous — Thu, 21 Mar 2013 14:08:54 GMT

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

Re: How to add Columns to a csv file?

_AnonymousUser — Thu, 21 Mar 2013 14:58:47 GMT

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

Re: How to add Columns to a csv file?

Anonymous — Thu, 21 Mar 2013 21:40:59 GMT

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

Re: How to add Columns to a csv file?

Anonymous — Fri, 22 Mar 2013 10:08:31 GMT

@esabot. It's working. Thx

Re: How to add Columns to a csv file?

Anonymous — Fri, 22 Mar 2013 12:55:14 GMT

Welcome to the Talend Community!