topic Re: TfileOutputDelimited issue in Talend Studio

TfileOutputDelimited issue

Anonymous — Thu, 22 Mar 2018 12:04:44 GMT

Hello,

How do i modify the output of my delimited file (csv) to be in a particular sequence.(i.e be in the format/sequence required by the third party system for upload). The output file is currently separated by ";" (semi colon). I want to include a static value(prefix) in all the rows and also do not want all of them to be separated by semi colon.

How do i go about this modification to generate my required output?

Kindly assist.

Thanks

Re: TfileOutputDelimited issue

TRF — Thu, 22 Mar 2018 12:10:47 GMT

Hi,

Add a field called "Prefix" to your schema and set its values from a tMap ou tJavaRow.

For the 2nd point, change the tFileOutputDelimited "Field Separator" to an empty string ("").

Should be enough.

Re: TfileOutputDelimited issue

Anonymous — Fri, 23 Mar 2018 12:44:17 GMT

Hi TRF,

Thank you for your response.

i was able to go ahead with the first one. but for the second one, this is my desired output file

Subject;joe1;Doe1 Joe1 .

Between Doe1 and Joe1, i do not want to have the semi colon (";") separator.

How do i configure the output to make the file look like that?

Re: TfileOutputDelimited issue

TRF — Fri, 23 Mar 2018 13:08:30 GMT

So it seems you want to marge 2 separated fields from your input.

Use a tMap for that.

Re: TfileOutputDelimited issue

Anonymous — Fri, 23 Mar 2018 13:56:20 GMT

No, i just want to use two different separators for the generated output file.

";" and " " an example is this: Subject;joe1;Doe1 Joe1.

currently, it is been separated by only ";"

How do i go about that?

Re: TfileOutputDelimited issue

manodwhb — Mon, 26 Mar 2018 06:11:47 GMT

@daescada since you can sepecify the multiple delimiters output file ,as shown below.

Re: TfileOutputDelimited issue

TRF — Mon, 26 Mar 2018 08:12:46 GMT

Hi,

You've shared the expected output but not the input.

Give a complete example to receive the appropriate answer to your case.

Re: TfileOutputDelimited issue

Anonymous — Tue, 27 Mar 2018 17:03:33 GMT

I have an application that i want to upload the data(users) into which requires it to be in this format

User;Subject;Ferguson1 Mark1 . Please take note of the 'space' between Ferguson1 and Mark1.

This means that it requires two different separators in a single row. (i.e) ";" and " ".

so the question is, how do i configure the output text to have those two separators in one row.

Thanks.

Re: TfileOutputDelimited issue

TRF — Tue, 27 Mar 2018 17:08:39 GMT

Once again, share your input schema.

Re: TfileOutputDelimited issue

Anonymous — Tue, 27 Mar 2018 17:18:03 GMT

see attached

input_output.PNG
schema.PNG

Re: TfileOutputDelimited issue

cterenzi — Tue, 27 Mar 2018 17:22:43 GMT

What you're describing isn't supported "out of the box" in Talend. You'll have to combine the data in the last column yourself. The best way to do that depends on what your incoming data looks like.

If the data is already together on one row, you'll want to combine the appropriate columns together, inserting your own delimiter (space) between the values.

If the individual values are on different rows, e.g.:
User;Subject;Ferguson1
User;Subject;Mark1

...you can use an aggregate component with the List function to roll up the rows. The advanced settings tab of tAggregateRow lets you choose the delimiter for the List column.

Update after seeing your schema:
Alter your tMap output schema to have only three columns. Make the third column's expression:
row1.Firstname + " " + row1.Lastname

Re: TfileOutputDelimited issue

Anonymous — Wed, 28 Mar 2018 15:58:26 GMT

Thank you