tFixedFlowInput and tFileOutputDelimited issue

Highlighted
Six Stars

tFixedFlowInput and tFileOutputDelimited issue

Hi everyone I have an issue with my delimited output file.

At first I'm using tFixedFlowInput to create a header after that I append my data.

 

02-08-_2019_15-45-03.png

The structure of my output txt file has to be:


ABC DEF
data1 data2
data2a data2b
data3a data3b

 

but my output looks like this:

 

ABC DEF data1a data1b
data2a data2b
data3a data3b

 

Below are my settings for the header

fixedflow.png

 

And for tFileOutputDelimited component

headline setting.png

 

and here for the data block. Is there any wrong? 

 

append data config.png

How I can fix this issue that the first row of appended data will be at a new line? 

 

Thanks for any hints.

 

Highlighted
Six Stars

Re: tFixedFlowInput and tFileOutputDelimited issue

Hi

 

You must use the same separator on the tFileOutputDelimited.  In this case my suggestion is that you use as row separator "\n" and field separator "\t" or ";",

so the output will be consistent.

 

Kind regards

 

 

Alfonso Borre

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

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog