Originally posted by: KK_WTX

I have one requirement as mentioned below.

Input:5|aj|hgsd|ashgf|jsdhf|ghsjk
5|aj|hgsd|ashgf|jsdhf|ghsjk
2|aj|hgsd|ashgf|jsdhf|ghsjk
2|aj|hgsd|ashgf|jsdhf|ghsjk
1|aj|hgsd|ashgf|jsdhf|ghsjk
3|aj|hgsd|ashgf|jsdhf|ghsjk
3|aj|hgsd|ashgf|jsdhf|ghsjk
1|aj|hgsd|ashgf|jsdhf|ghsjk

Here first i sorted the data based on the unique_id and finally i want to genarate outputs based on the unique id's.

Ex:Required outputs as below.
output_1.txt,output_2.txt,output_3.txt,output_5.txt

Before going to call RUN function i want to split the data into unique data sets(1,2,3,5) and than send to the map. Appreciated your help..?

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

Originally posted by: VinothKumar.D

1) Using the UNIQUE function and collect the Unique ids .
2) Now loop this Unique id's, inside every loop , EXTRACT the records for matching corresponding Unique id .
3) Even we can call the RUN function and pass this data from this loop itself ...

Reference :

card 1 : Collect the Unique ids
card 2 : Can be as shown below ..

Group(s) ==> Loop the Unique ids
- Records(s) ==> Extract the records for corresponding Unique id
- Item (0:1) ==> Call a RUN function and pass the above Record as input .

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

Originally posted by: SystemAdmin

Using UNIQUE is, I'm afraid, not the right way to do this.

Using a proper type tree is the way to go, and the efficiency will be much better when the data groxs in size.

Please have a look at the attached sample (WTX 8.1).
Laurent from SATISCO
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: KK_WTX

Now Got it...Cheers :)
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender