Question on message mapping - wrt to split by value node function
I have the following source structure : which is the result of a sql select ( SQLsender adapter )
In the target, we have a idoc with an unbounded structure
IDOC ( 1 to unbounded )
Now, for every change of value of field f1 , I want to create a new idoc.
I did the following :
1. Changed context of field f1 to point to message type mt1
2. Use split by value ( change of value option ) against field f1 and pointed to target - idoc unbounded node.
In my test sample, I have total of 9 records, sorted by field1. First six records have value 'A' for field1 and last three records have value 'B'. I expect two idocs to be created.
But I see six idocs being created ( for the first six records ) . Where am I going wrong ? Is SplitByValue the right node function to use here.