topic Multiple rows should be converted as single record in Fixed width file in Talend Studio

Multiple rows should be converted as single record in Fixed width file

nar — Sat, 16 Nov 2024 01:09:38 GMT

Hi Team,

I have a Fixed Width file with data as shown below. First 10 rows in file should be considered as a single record. i have to change first 10 rows as a single record and then i have to read the data in length. the below data has 20 rows and this should be

converted to 2 records. Can anyone help me to achieve this.

01000000101004803279999999999999910001000000000000000000000000053117000000000001

02000000151389115000005314912060106010601840840 0121321180379 1321180379 00

030000001015267061 0009922600099226 First Tech FCU 1010100024

040000001Mobile Deposit First Tech DDDAUSA84000000000000002780000000000

0500000010408400000000000000 000000000000 000000000000

060000001 000000000140000000001

0700000016011F0N13327CCCCA2PRCB2235 840 200601 0000000019094200

0800000010000000000000000000000000183640000000000000231101321180379 VERSLI

090000001530090=

100000001 AH

01000000201004803279999999999999390000000000000000000000000000053117000000000001

02000000251389115000005314912060106010601840840 0121321180379 1321180379 00

030000002015267061 0009922600099226 First Tech FCU 1010100024

040000002Mobile Deposit First Tech DDDAUSA84000000000000002780000000000

0500000020408400000000000000 000000000000 000000000000

060000002 000000000140000000001

0700000026011F0N13327CACCC2PRCB2235 840 200601 0000000019094200

0800000020000000000000010000000000183640000000000000231101321180379 SLI

090000002530090=

100000002

Re: Multiple rows should be converted as single record in Fixed width file

Anonymous — Mon, 09 Nov 2020 06:19:35 GMT

Hello,

Please have a look at this component: TalendHelpCenter: tFileInputPositional

which can read a positional file row by row to split them up into fields based on a given pattern and then sends the fields as defined in the schema to the next component.

Best regards

Sabrina

Re: Multiple rows should be converted as single record in Fixed width file

nar — Tue, 10 Nov 2020 17:56:19 GMT

Thanks for your response xdshi.

What you mentioned i know how to handle that. but in my case i have to concatinate 10 rows as a single record. please find below for more undrestandi.

Source File Data.

output should be like this.

01020304050607080910

11121314151617181920