Originally posted by: SystemAdmin

Hi All,
I need your help in learning the transformation process (wtx7.5). I have gone through tutorials given in the pdf but not getting the right start ..
basically when I check the 1st example contactolabel map file - I am failing to understand
1. what is the need of putting the data's in a group file
2. cant i directly put in the fields in mtt and directly convert
3. Can any body show me a step by step example of converting as below ( as the example already contains mtt)
convert a text file containing below line

sidharth,29,Assam
Manash,30, Orissa

to
Sidharth
29,Assam
Manash
30, Orissa

Your help & time is appreciated and am grateful for that - in advance

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

Originally posted by: janhess

You need to understand your data structures.
Input file has the structure
File
Records
Record Items

File is a Group as it contains records. Record is a group as it contains items.
The data fields are Items.
You need to define 3 Items
Your record contains the 3 items and is defines with a comma delimiter. The record has a new line terminator.
File contains multiple occurrences of records.

Your output file has 2 record types - name and address (I think)
So the output has a File, 2 record types and the data items.
The records need to be in a group as the file is an occurring collection of record 1 and record 2.

So you will have

File containing multiple occurrences of RecordGroup
RegordGroup containing 1 occurrence of Record 1 and Record 2
Record 1 containing name item terminated with new line.
Record 2 containing address items terminated with new line.
3 data items.
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

Hi Janhess,
Many thanks for your explanation - I think I got it ...
Thanks for your time - in making me understand the basics -

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