Originally posted by: repanzer
Anytime you have different data to pass to the output, you have to have a new functional map. What I do is use the EITHER command;
In the event input2 is not present;
=EITHER(f_map1(input1, input2), fmap2(input1)
But both maps needs to be created.
The only possible solution I can think of for your dilemma, is to use EITHER on the field level, if that's possible. I have not tested this nor had a need to.
Like:
=f_Map(input1, EITHER(input2,"placeholder"))
If it allows EITHER in the fmap statement, the challenge will be, that input2 and "placeholder"...HAS TO BE OF THE SAME TYPE. In this case, text. As far as I know, you can not do on the fly adjustment to the types in functional maps.
I know there's a function REFORMAT, but I've never used it (nor understand it).
#IBMSterlingTransformationExtender#IBM-Websphere-Transformation-Extender#DataExchange