Originally posted by: SystemAdmin

Hi everybody. I have an input file with records and a lot of fields in each record. One of those fields has some limited amount of possible values (like SAL, SEL, RET, etc... ). Does anyone know if there is a way in WTX to sort those records by that field, setting a priority to each one of those values?
Thanks
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: repanzer

If you mean you want them sort by the codes in this field by priority and not alphabetically, you could have an input reference file with each possible code in each record, like

A
C
B

In the priority you want, then in a functional map, you take each code in the reference file and EXTRACT(record where field in record = current code from my cross reference)
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender