Originally posted by: Kepa_Screen

Hello.

I had to process a file, with different kind of lines inside it.
I attach data file.

These different lines begin with different header:

00.00 its used like "head" line
99.00 its used for "foot" line

And the other ones are

51.10 xxxxxx
51.20 yyyyyy
51.30 zzzzzz

I only have to treat 51.20 and 51.30 lines, i mean, output for other record types may be the same as input, without doing anything to those lines.

When a 51.20 record arrives, the output for that line would be different than input one, only one item at the line would change ( calling to a dblookup function ). The same with 51.30 records ( other item must be calculated for the output depending on another item in the input, calculated via dblookup function).

I would like to use the "Choice" type, at the type tree construction, in order to expecify that one line could be of different types, and make a call to a functional map, which would calculte the items to change if the record is type 50.20, or 50.30, and to put output=input in the other cases....but don't know how to use, it. ( choose function, i mean ).

Could anybody help ? Thanks a lot in advance.

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

Originally posted by: SystemAdmin

I'm not clear on why you want to use a Choice group. Why not just define regular records with a 5-byte fixed length field called "RecID" as the first field? You then enter a component rule in the Type Tree for each different record's RecID field like $="51.20". Then set the 51.20 record as an Identifier for the Detail Group.

00.00 1:1
51.00 1:1
51.20 1:1 --+
51.30 1:1 --+ Detail Group 1:s
51.99 1:1
99.00 1:1

Jim Divoky
EC Solutions, Inc.
330-606-6826
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: NancyR

I've attached a type tree and map. I used a partitioned group. The last partition will catch any lines that are not one of the record types you want to process. It must be last in the list.

Also, I've used a text blob as the single component for each of your record types for simplicity but you can replace those with structured groups.

Hope this helps you.
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: Kepa_Screen

Thank you very much for your help.
I'll give a look to the files you attached, and will update this topic with feedback.

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