Need a logic to each iteration fetch 500 records from accumulated output.

[akila krishnan]

I have accumulated ouput. it have more than 1000 records, i need to fetch 500 records from that in each iteration, those data will be send to Call process. How can be implemented in Tibco BW 6

[Emmanuel Marchiset 2]

To do this you need to create an intermediary grouped list.

 

Assuming your input list is a list of Records in the form :

List

-> Record*

The principle would be the following :

. Created a grouped list of Records (a new XML schema) in the following form :

List

-> Group*

-> Record*

. Map the input list to the grouped list using a mapper with the 'for each group' statement and using the 'position() mod 500' (modulo) as groupid

. You now have your list in groups of 500 records

. Create a iteration on the list of groups (from the grouped list)

- in the iteration call the sub-process with the 500 records of the current group

 

I think this should help, if you are still stuck let us know