Originally posted by: SailajaChaganti

Hi,

I am using WTX 8.3 for transformation purposes. The source file can be one of three different formats, Proprietary fixed length format , Proprietary CSV format and ANSI format (843 transaction). My output is a single XML. In WTX, do we have the capability to use 3 input cards but my input is going to be of only one type at any given time. Is WTX capable of deciding the input card against which the incoming file has to be validated and perform the transformation?

Please let me know if I am not clear.

Thanks,
Sailaja.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

i would have a different map for each data format (i.e. 3 transformation maps in your case).

you'd then need a map to determine the format of input data (call this the 'Receive' or 'Router' map).

the Receive map could either call the appropriate transformation map directly using the RUN function or it could output the data as a file using a file name e.g. *.dat, *.csv, *.x12 that would be picked up by the appropriate transformation map.
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: NancyR

Use a choice group for your input card with each of your three formats as components. Then use a rule with EITHER using a funtional map for each of your formats:

=EITHER(F_format1(arguments), F_format2(arguments), F_format3(arguments) ).
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender