topic Re: How to overwrite tFileOutputDelimited file if exists in Talend Studio

How to overwrite tFileOutputDelimited file if exists

Anonymous — Thu, 03 May 2018 20:07:21 GMT

is there any option to overwrite existing file when using tFileOutputDelimited. I only see Append.

thank you!

Re: How to overwrite tFileOutputDelimited file if exists

TRF — Thu, 03 May 2018 20:15:49 GMT

Untick both options Append and Error if file exists (or something like that)

Re: How to overwrite tFileOutputDelimited file if exists

Anonymous — Thu, 03 May 2018 20:17:39 GMT

I want the new file to overwrite if the such file already exists. I don't want the job to error out.

Re: How to overwrite tFileOutputDelimited file if exists

Anonymous — Thu, 03 May 2018 20:22:58 GMT

I see what you are saying. I unticked both options and it worked. thanks so much.

Re: How to overwrite tFileOutputDelimited file if exists

Anonymous — Fri, 26 Apr 2019 07:32:29 GMT

Hi,

I don't see that option in the tFileOutputDelimited! Could you please tell me where that untick option?

Re: How to overwrite tFileOutputDelimited file if exists

Anonymous — Fri, 26 Apr 2019 07:44:09 GMT

@sm

Here you go!

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: How to overwrite tFileOutputDelimited file if exists

Anonymous — Fri, 26 Apr 2019 12:55:39 GMT

Thank you. I have a requirement like this.. I need to capture the rejected rows by applying multiple rules/conditions, here I want to append the rejected columns with 2-4- tmap reject criteria, so I will not be knowing which tmap has generated rejected rows, so I need to enable the append in all the reject criteria by writing to the same file. This is working fine but when running for the second time again same data gets appended instead of writing fresh into the file, for now what I have done is added a tFileDelete at the beginning, so it is creating a fresh file though append is enabled in all the tFileoutputDelimited component.

May be some other way may also be there, if so please advice.