How to repeat record in the same row

, ,
1

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

2

Shiva,

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

HTH,
RMG

3

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


sample.txt (0.1 k)

4

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

5

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