Hi All WebMethodsGeeks,

I’m having some problem in creating a recordList inside a recordListList.

The Requirement is shown using below structure.

→
DetailRecord
Field1
Field1
Field1
Field1
NoOfPairs → some count
a_1
b_1
a_2
b_2
a_3
b_2
…
…
…
a_NoOfPairs
b_NoOfPairs

I’ planning to create the schema in the following way for DetailReord.
DetailRecord → recordList
Field1
Field1
Field1
Field1
NoOfPairs → some count
PairList à recordList
a
b

Currently I created in the above way, but first fields are coming properly, and the pairList is coming with only two fields. The fields repetition is not
happenning.

Hi Mratala,
The doc structure you wrote is not clear enough.

Is it like follows:

DetailRecordList
—Field1
—Field2
—Field3
—Field4
—NoOfPairs
—PairList
------FieldA
------FieldB

If yes, then you will have to have 2 LOOPS in your FLow something like this:

LOOP on DetailRecordList
—Map to Field1, Field2, Field3, Field4 and NoOfPairs
—LOOP on PairList
------Map to FieldA, FieldB

Regards,
Bhawesh

Hi Bhawesh,

Thanks for the reply, my First step is to put the Flat file into a document.

The Sample Flat File Structure looks like this.

“H00”,12345678,4,2
“D00”,12345678,“IMAGEID1”,4,“drawing1.png”,5,0000001,0000011,0000002,0000022,0000003,0000033,0000004,0000044,0000005,0000055
“D00”,12345678,“IMAGEID2”,8,“drawing2.png”,4,0000001,0000011,0000002,0000022,0000003,0000033,0000004,0000044
“T00”
I have to get this data into a document, with the following structure.
DetailRecordList
—Field1 → “D00”
—Field2 → 12345678
—Field3 → “IMAGEID1”
—Field4 → 4
—Field5 → “drawing1.png”
—NoOfPairs -->5
—PairList → This will contain all the values. every first field starting 0000001 goes into FieldA, every second field starting 0000011 goes into FieldB
------FieldA → 0000001
------FieldB → 0000011
The Schema is not working properly to push the data into the PairList.
Any ideas are greatly appreciated

Rgds,
Arjun.

Hi Arjun,
You need to define the PairList as the Composite Field (with the ocuurance set as 1…N) while defining the Flat File Schema.

Please go through the “Flat File Schema Developers Guide.pdf” for more info.

HTH,
Bhawesh.

hi arjun…
your flatfile schema should be something like this.
H00
D00(record list)
T00
…
becouse each D00 is a record …and the flatfile schema should parse the record using field identifier as ‘,’ and record identifier as “newline”
guess this should do the trick…
hopefully if i understood the structure of flatfile right.
HTH
sri