Thanks to our intuitive transformation designer, you can convert data effortlessly to a variety of formats without knowing how to program. It’s not only efficient, it’s also easy to use.
Hi,
I was wondering if there is a way to append records (or to identify the first available empty row) of a text file.
In fact, i have to write the data into a flat text file with a structure " header detail trailer records" (each record wth own specific fileds) so, I am using 3 different flowheater definition, and then, i manually merge all the single text files. So,I would to automate this final step if it possible...
The TextFile Adapter supports appending data to text files. You have only to activate the "Append to file" option in the TextFile Adapter Configurator (first tab). Currently if FlowHeater appends data to an existing file no header lines are written
You can download
here
a quick modification. With this (beta) version it is possible to add data to existing text (CSV) files including the header (field names) information.
To use this you have to set the NEW TextFile
Adapter property
"AppendHeaderAlways" to TRUE. Hereby FlowHeater writes always the header (field names) to an existing file.