topic Re: tFileOutputDelimited with 2 line custom header in Talend Studio

tFileOutputDelimited with 2 line custom header

Anonymous — Wed, 27 Jun 2012 21:20:48 GMT

Hi
when populating a delimited file from a DB , i can choose that it include HEADER...
how do i create said output with my own 2 line header , with my relevant details .
and then bring in my data
Regards
============================================================================
example:
FILTYPE00001-as7vlkdf9923j-kljsda89823m-20110637051002 //HEADER line 1 - file information i.e. file type , guid , date
#data1~data~data3 //HEADER line 2 - same as header but starts with #
data1~data2~data3 //row1 from data DB
data1~data2~data3 //row2 from data DB
data1~data2~data3 //row3 from data DB

============================================================================

Re: tFileOutputDelimited with 2 line custom header

Anonymous — Thu, 28 Jun 2012 04:33:53 GMT

Hi
A workaround is to load these 2 line header first into one output delimited file and then load other rows by selecting "append" option on tFileOutputDelimited.
Regards,
Pedro

Re: tFileOutputDelimited with 2 line custom header

Anonymous — Thu, 28 Jun 2012 11:35:05 GMT

Hi Pedro
sorry still new to talend
I understand the concept what component do i use to populate the file withe the header
as the first line of the header has a string describing filetype , then i insert a GUID and getDate() for the date
(i used String newGUID = java.util.UUID.randomUUID().toString() to generate and assigned it as global, using globalMap.put("GUID",newGUID)
the second line being the schema data header bu prefixed with #.
could you elaborate :
i am trying the following , see screen shots

and pass that to my first output file ... but no luck

Re: tFileOutputDelimited with 2 line custom header

Anonymous — Fri, 29 Jun 2012 06:37:33 GMT

Hi
The error is because tJavaFlex cannot link tFileInputDelimited.
You might create a job as the following image.
There is no need to use tJavaFlex here.
Regards,
Pedro