Originally posted by: HBR4_mohd_kamal_fikri_puadulza

Hi, I need some help in setting the max value for group item. There is a set range option where we can set 0:1 or 0:s and something like that. In my case I need to refer to the occurance field to determine the number of times the group need to be repeated. There is no terminator or delimeter. Let's say if I have a record say names (name1, name2 and name3) and ID (001,002 and 003) repeat 3 times and there is a occurance value '03'. How to make the type tree to refer to the occurance field to do the looping?

03*name1001name2002name3003*
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: NancyR

If you're just trying to create the correct number of records, a functional map will do the trick. If you're trying to validate your data to ensure you have the correct number of names and IDs in your input, use a component rule in the type tree. For both groups use a rule like COUNT(Group IN File)=OccurrenceCounter
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: TarunB

The CLONE function within a functional map would prove useful in this case.

You would still need to be able to define your input structure, so that a "record" is distinguishable. From your example below, a fixed length format would appear to fit well.
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender