Generating multiple recordset names

[santosh_k3]

Hi All,

I am doing a scenario which is File to IDOC.

I am reading a file which is of variable structure , so in FCC i have used the RecordSet Sequence : Variable

after reading the file i have the structure as

example:

- <RecordSet>

- <W6>

<WE601 />

<W602 />

<W603 />

<W604 />

<W605>D</W605>

</W6>

- <N1>

<N101>ST</N101>

<N102>ZZ</N102>

<N103></N103>

<N104></N104>

<N105>R</N105>

<N106 />

</N1>

- <N4>

<N401>ST</N401>

<N402></N402>

<N403>SD</N403>

<N404></N404>

<N405>US</N405>

</N4>

- <N1>

<N101>WH</N101>

<N102>ZZ</N102>

<N103>2070</N103>

<N104> SCS</N104>

<N105 />

<N106 />

</N1>

- <N4>

<N401>WH</N401>

<N402></N402>

<N403></N403>

<N404></N404>

<N405>US</N405>

</N4>

</RecordSet>

But i have to get the recordset name <RecordSet> twice as given below after mapping

- <RecordSet>

- <W6>

<WE601 />

<W602 />

<W603 />

<W604 />

<W605>D</W605>

</W6>

- <N1>

<N101>ST</N101>

<N102>ZZ</N102>

<N103></N103>

<N104></N104>

<N105>R</N105>

<N106 />

</N1>

- <N4>

<N401>ST</N401>

<N402></N402>

<N403>SD</N403>

<N404></N404>

<N405>US</N405>

</N4>

</RecordSet>

- <RecordSet>

- <W6>

<WE601 />

<W602 />

<W603 />

<W604 />

<W605>D</W605>

</W6>

- <N1>

<N101>WH</N101>

<N102>ZZ</N102>

<N103>2070</N103>

<N104> SCS</N104>

<N105 />

<N106 />

</N1>

- <N4>

<N401>WH</N401>

<N402></N402>

<N403></N403>

<N404></N404>

<N405>US</N405>

</N4>

</RecordSet>

i.e., i am getting 1 recordset after FCC and then after mapping i need to generate 2 recordsets and pass 2 IDOCS.

Please suggest me how can i generate multiple recordsets.

Thanks

Sai_SHA

[santosh_k3]

Hi All,

sorry the requirement is a different one

I am reading a file which is of variable structure , so in FCC i have used the RecordSet Sequence : Variable

after reading the file i have the structure as

- <RecordSet>

- <W6>

<WE601 />

<W602 />

<W603 />

<W604 />

<W605>D</W605>

</W6>

- <N1>

<N101>ST</N101>

<N102>ZZ</N102>

<N103></N103>

<N104></N104>

<N105>R</N105>

<N106 />

</N1>

- <N4>

<N401>ST</N401>

<N402></N402>

<N403>SD</N403>

<N404></N404>

<N405>US</N405>

</N4>

- <N1>

<N101>WH</N101>

<N102>ZZ</N102>

<N103>2070</N103>

<N104> SCS</N104>

<N105 />

<N106 />

</N1>

- <N4>

<N401>WH</N401>

<N402></N402>

<N403></N403>

<N404></N404>

<N405>US</N405>

</N4>

- <W6>

<WE601 />

<W602 />

<W603 />

<W604 />

<W605>D</W605>

</W6>

- <N1>

<N101>WH</N101>

<N102>ZZ</N102>

<N103>2070</N103>

<N104> SCS</N104>

<N105 />

<N106 />

</N1>

- <N4>

<N401>WH</N401>

<N402></N402>

<N403></N403>

<N404></N404>

<N405>US</N405>

</N4>

</RecordSet>

But i have to get the recordset name <RecordSet> twice , as the file is of variable structure i cannot go for RecordSet Sequence : Ascending .

- <RecordSet>

- <W6>

<WE601 />

<W602 />

<W603 />

<W604 />

<W605>D</W605>

</W6>

- <N1>

<N101>ST</N101>

<N102>ZZ</N102>

<N103></N103>

<N104></N104>

<N105>R</N105>

<N106 />

</N1>

- <N4>

<N401>ST</N401>

<N402></N402>

<N403>SD</N403>

<N404></N404>

<N405>US</N405>

</N4>

- <N1>

<N101>WH</N101>

<N102>ZZ</N102>

<N103>2070</N103>

<N104> SCS</N104>

<N105 />

<N106 />

</N1>

- <N4>

<N401>WH</N401>

<N402></N402>

<N403></N403>

<N404></N404>

<N405>US</N405>

</N4>

</RecordSet>

- <RecordSet>

- <W6>

<WE601 />

<W602 />

<W603 />

<W604 />

<W605>D</W605>

</W6>

- <N1>

<N101>WH</N101>

<N102>ZZ</N102>

<N103>2070</N103>

<N104> SCS</N104>

<N105 />

<N106 />

</N1>

- <N4>

<N401>WH</N401>

<N402></N402>

<N403></N403>

<N404></N404>

<N405>US</N405>

</N4>

</RecordSet>

i am getting 1 recordset after FCC but i need to get 2 recordsets.

Please suggest me how can i generate multiple recordsets and pass and pass mutilple IDOCS.

Thanks

Sai_SHA.

[Former Member]

Hi.

Can you put your FCC parameters?

Regards

[former_member184681]

Hi,

This is only a matter of building target structure and message mapping properly. Set the occurrence of RecordSet in target structure to 0..unbounded. Then map the N1 or N4 (I don't know which one is decisive here) to RecordSet in MM. Map header data (W6 as far as I understand) to each created RecordSet node (useOneAsMany) and N1 and N4 nodes to every single RecordSet.

Hope this helps,

Greg