Seperate dupes using one transfomer

krisp321 · Post by **krisp321** » Wed Jan 12, 2011 11:38 pm

Hi
I have a question

I want to seperate all dupes into one file and without duples into other file only just by using transformer. Can we do that. We can seperate duplicates using two stage variables which is easy but in this case I have a diff. requirement
Let us take an example

Input OutFile1 OutFile2
A A A
A B A
A C B
B D D
B E D
C
D
D
D
E

This can be done easily with two stage variables
But my requirement is

Input OutFile1 OutFile2
A A C
A A E
A A
B B
B B
C D
D D
D D
D
E

Can we achieve this using only one transformer and any number of stage variables?

Thanks in advance

Sreenivasulu · Post by **Sreenivasulu** » Thu Jan 13, 2011 3:22 am

Why do you want to achieve this using only one transformer?

Regards
Sreeni

ray.wurlod · Post by **ray.wurlod** » Thu Jan 13, 2011 4:43 am

Start by describing, in English, the algorithm that gets from the input to the output. For example, how does A A C come about?

Then answer the "why" question. This would be much more easily accomplished using two Transformer stages, it seems to me.

krisp321 · Post by **krisp321** » Thu Jan 13, 2011 5:17 am

Sreenivasulu wrote:Why do you want to achieve this using only one transformer?

Using Transformer and Lookup stage we can achieve this, but I have this requirement multiple times for a particular accounting. So, I was trying to reduce the number of stages rather than whole bunch of stages using again and again.

Just wondering if that is possible, from my end i tried but i couldnt figure out. So, just looking for any possibility from here.