Originally posted by: SystemAdmin

Hello! Have a transform map with one input and one output card currently.

Need to match on SSN to a table and pull off the first and last name and the marital status, and place these in three distinct output card fields.

Have done table lookups previously both in the same map and also from a Run Map call. However, those only had to retrieve one field on a match. Trying to avoid having three different lookups, one for each rule on the output card for the necessary fields.

Not sure how to retrieve the table data and parse it into three different output fields and also how and where to put the one lookup or Run Map call in the current map.

Would need another input card for the table if do a lookup but if a Run Map is used then that table input can be placed in that map.

Would appreciate any help or examples regarding this map.

Thanks!
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange