[resolved] t_FileOutPutMSDelimited Header and Trailer Rows

One Star

[resolved] t_FileOutPutMSDelimited Header and Trailer Rows

I'm trying to create a multi schema delimited file and I need to create 1 row at the start and end of the file for the header and trailer. These rows are not linked to the other rows in the schema and don't need to be linked by any key.

It works fine without the header rows, but as soon as they are added i get a bunch of error messages.

Does this component support the ability to add such header and trailer rows?
One Star

Re: [resolved] t_FileOutPutMSDelimited Header and Trailer Rows

If anyone has ideas, i'm in a bit of a bind with this one?
Community Manager

Re: [resolved] t_FileOutPutMSDelimited Header and Trailer Rows

Hello
It is impossible to generate header and trailer row on tFileOutputMSDelimited directly. Well, you use the option 'append' on tFileOutputDelimited to generate header, body and trailer rows.
eg:
tFixedFlowInput(generate header to target file)-->tFileOutputDelimited
|
onsubjobok
|
tMysqlInput_1---tFileOutputMSDelimited (output the result to a temp file)
|
tMysqlInput_2
|
onsubjobok
|
tFileInputFullRow(read the temp file line by line, and append them to target file)--->tFileOutputDelimited(target file, check 'append' option)
|
onsubjobok
|
tFixedFlowInput(generate trailer row to target file)---->tFileOutputDelimited(target file, check 'append' option)


Best regards

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: [resolved] t_FileOutPutMSDelimited Header and Trailer Rows

Great, Thank you shong. Works a treat.

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Have you checked out Talend’s 2019 Summer release yet?

Find out about Talend's 2019 Summer release

Blog

Talend Summer 2019 – What’s New?

Talend continues to revolutionize how businesses leverage speed and manage scale

Watch Now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog