Originally posted by: SystemAdmin

I have a series like below

01DATE1TIME1TMZ1DATE2TIME2TMZ2DATE3TIME3TMZ3
02DATE4TIME4TMZ4DATE5TIME5TMZ5
02DATE4TIME4TMZ4DATE5TIME5TMZ5

I have managed to do this when all dates exist using functional maps but when one of the fields is missing it passes a NONE which causes the functional map to not run. Any ideas a good way to get round this without using lots if IF(PRESENT()&PRESENT()) statements?
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: SystemAdmin

I have a series like below

01DATE1TIME1TMZ1DATE2TIME2TMZ2DATE3TIME3TMZ3
02DATE4TIME4TMZ4DATE5TIME5TMZ5
02DATE4TIME4TMZ4DATE5TIME5TMZ5

I need to get the minimum date from all series, I have managed to do this when all dates exist using functional maps but when one of the fields is missing it passes a NONE which causes the functional map to not run. Any ideas a good way to get round this without using lots if IF(PRESENT()&PRESENT()) statements?
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: SystemAdmin

I don't understand. So the input is a group of a few fields, each containing date/time/timezone. You're running a functional map using the series, but sometimes there is a blank in the series, like 1,2,3,,5? Are you using the MIN function?
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: janhess

Use the function EITHER on the patameter so that if it is present it is passed otherwise pass a dummy value.
E.G, Either(date field,"9999/12/31")
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SystemAdmin

You could define the optional fields with 0:1 range in the type tree.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange