Read and Write to the Same CSV file Possible ?

GheZaide — Sat, 16 Nov 2024 00:11:21 GMT

if i read and write to the same filename it is giving 0 rows

but if i write on a new file it's working

UseCase: csv1 = holds the initial value Date >>> after run the csv1 should have the updated value Current RunDate

if i disable the tFileOutput for the meantime i am seeing the expected value

or if i assign it to a new file

Re: Read and Write to the Same CSV file Possible ?

Anonymous — Thu, 06 May 2021 04:53:37 GMT

The tFileOutputDelimited will create an empty file with the same file name before the file is read, that's why 0 rows are read from the file, about the code generation model, you can refer to this page on Talend Help Center.

As a workaround, cache the data into memory and read the data back in next subjob, eg:

tFileInputDelimited--tJavaRow--tHashOutput

|onsubjobok

tHashInput--main--tFileOutputDelimited.

Regards

Shong

topic Read and Write to the Same CSV file Possible ? in Talend Studio

Read and Write to the Same CSV file Possible ?

Re: Read and Write to the Same CSV file Possible ?