How to repeat record in the same row

We have a requirement to create flat file as per below layout

a1;a2;a3 are fields of a record which repeats unlimited times in the same row and delimiter is “;”.

a1;a2;a3;a1;a2;a3;a1;a2;a3;………….; --> Layout – a1;a2;a3 repeats unlimited.
11:12;13;21;22;23;31;32;33;41;42;43; --> Sample data

I could able to repeat above structure line by line (as per mark suggestion).
But our requirement is to repeat record structure in the same row.

Any suggestions?

Regards,
Shiv

Shiva,

Please try to upload your sample flatfile,this way we can analyze and guide you per format.

HTH,
RMG

RMG,
Please find the attached sample file.
Regards,
Shiv


sample.txt (0.1 k)

Shiva,

What you can do is create schema with RecordDefinition (recordWithNoID)and set properties maxrepeat(unlimited) and define field definition with record delimiter is ;.once you convertToString then tokenize(with delimiter ;)and use makeString to whole one line with delim ;

but this is a work around and testing.

HTH,
RMG

Thanks RMG…
Flat file layout has 150 fields. For first 140 fields I planned to use flat file schema. For remaining fields I will use “makeString” service with ‘;’ as delimiter. Finally I will append these two strings to get final output.

regards,
Shiv