Originally posted by: SystemAdmin

Haven't done this before. Need to see if there's a way for me to grab the 'Last' output from group a while executing a runmap in group b.

For example, I'm 3 f_maps deep. I have 2 record types in group A, A1 and A2. I populate A1 until I reach an input that meets A2 requirements. When I populate A2 I also need to get a piece of data from the last A1 populated.

The tree is designed something like this

Output File:
Group A (1:S):
Record A1 (1:S)
Record A2 (0:S)

A2 is actually executing a run map.

Run (map_X, Echoin (1, (package (input)) + Echoin (2, seriestotext (Record A1)).........

What is the syntax for getting the last A1?

jvanboga
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

=Run ("map_X", Echoin (1, (package (input)) + Echoin (2, seriestotext (Record A1),ECHOIN(3,PACKAGE(RecordA1LAST:File)))

(it is not case sensitive).

Hope this helps.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SystemAdmin

Thanks, I'll give this a try.

I thought it might go there but couldn't get it to work. It's the extra occurance I think I blew it on.

jvanboga
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

That worked. Thanks again.

jvanboga
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: SystemAdmin

How would I the one before last back?
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SystemAdmin

=Run ("map_X", Echoin (1, (package (input)) + Echoin (2, seriestotext (Record A1),ECHOIN(3,PACKAGE(CHOOSE(RecordA1 in File,COUNT(RecordA1 in File)-2)))

The paranthases might not be correct.

This should work.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange