topic tFileOutput dynamically filename in Talend Studio

tFileOutput dynamically filename

Anonymous — Sat, 16 Nov 2024 13:29:24 GMT

Hello everyone,
i am stuck within a simple? problem.
If have a small process to extract data from a big xml file and save the output it in several small files.
the filename of each output file is dependent of the actual data.
example inputfile:
<PLANT>
<COMMON>Bloodroot</COMMON>
</PLANT>
<PLANT>
<COMMON>Columbine</COMMON>
</PLANT>
output files:
bloodroot.xml
columbine.xml
I extract the 'common' property into the context variable : context.FILENAME
But at execution time i only get one file: null.xml
How can i dynamically set the filename of the tfileoutput component?
Thanks your help
Michael

Re: tFileOutput dynamically filename

Anonymous — Mon, 29 Mar 2010 10:08:07 GMT

Does nobody have a tip or workaround for that?

Re: tFileOutput dynamically filename

Anonymous — Tue, 28 Dec 2010 14:55:26 GMT

You are using correct file name but I think context variable are not initialized with proper values
You are using two context variables context.OUTPUTPATH, context.FILENAME
Try displaying data contained in 'common' property and context variables
Also select check box Append in tFileOutputDelimited so exisiting files are appended

Re: tFileOutput dynamically filename

alevy — Wed, 29 Dec 2010 05:42:00 GMT

The output file is initialised before the flow starts i.e. before the input file is even opened so you can't use values from the input for the output file name. There are other posts about how to achieve this e.g. https://community.talend.com/t5/Design-and-Development/spliting-files-an-renaming-files/td-p/72252.

Re: tFileOutput dynamically filename

Anonymous — Wed, 29 Dec 2010 08:58:09 GMT

The output file is initialised before the flow starts i.e. before the input file is even opened so you can't use values from the input for the output file name.

Thats correct!
I used this approach:
Write the data to tempfiles and at the end rename your files to the appropiate name.