Originally posted by: Aprithvi

I have an huge XML file with multiple records each of which is an XML. each record translates into one line in the flat file output.
One of the fields in the output is a sequence number which starts with 1 and has to increment all the way till the end of writing all records. How do I achieve that? The output should be as below. I need to get 1 2 3 4 as a sequence number in the output.

Date history time effort 1 currency
Date history time effort 2 currency
Date history time effort 3 currency
Date history time effort 4 currency
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: Dhiren.Ghelani

Have you looked at the index function? try passing index($) at the functional map where you are looping.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: repanzer1

Yeah, either the INDEX function or the GETANDSET function.

---

There are 10 types of people in this world. Those who understand binary and those who don't.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: thorstenhirsch

Please don't use GETANDSET. It changes values on cards that have already been processed, so it's like "goto", but in a programming environment that normally works completely sequential. That damn function breaks the concepts of wtx and should be made obsolete asap, but I guess too many customers already use it heavily.
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender