Group Maximum Occurence 1

Hi all

I have Project, that use SQL adapter to extract data from the DB

At the end of the process the data is sent as Flat file  Ascii

Description
—————

Schema A = 6 Elements  = SQL
Schema B = 2 Nodes; Node Y and Node Z 

Hence OutPut =

100;20;13.03.08;254
100;10;13.03.08;254
200;6316001658010707;0152017145010707;2
200;5316001658010707;0152017145010707;2
200;4316001658010707;0152017145010707;2

The Out put above is what I am getting now..

But I need to have

100;10;13.03.08;254
200;6316001658010707;0152017145010707;2
200;5316001658010707;0152017145010707;2
200;4316001658010707;0152017145010707;2

I.e ; Node Y must appear only once..

what will I sent in the Schema node of Y or in the Map to acheive the intended out put

Thanks in Advance

Ed