if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok

if a column contains data like
abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc,
roy,pwe,aaa,xxx,xyz,roy,xok....
how to send the unique data to one source and remaining data
to another source????

Question Posted / sourya2009

3 Answers
7735 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,p..

Answer / chandu

S.D sahu answer is correct but don't use transformer stage.

use sort stage and use option as createKeyChangeColumn =
True it allows one virtual key column as keychange column
i.e unique records display as 1 and duplicate records it
give 0 and use simple filter stage and that use option or
give where clause =keychangecolumn=1 . unique records are
went to one dataset and use filter stage stage another
option is output rejects =true duplicate records went to
another dataset.

This is the best answer

Is This Answer Correct ?

21 Yes

1 No

if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,p..

Answer / s.d sahu

First use aggregator stage use rowcount,then use transformer
rowcount=1 to one source rest to another.

Is This Answer Correct ?

5 Yes

6 No

if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,p..

Answer / prasad

by using create key change column is true is disp;ays
duplicates records
if it is false it displays non duplicate records
first keep all the records in sort order

Is This Answer Correct ?

4 Yes

6 No

Post New Answer