This is the flow of transformations you need to follow,
First you need to sort the data,for this use sorter.
In expression transformation you need to create following ports,
Here FIELD9 is the column name which contains product key for me.
for v_count you need to use following condition,
The output from this expression will be in the form of,
Product, O_count
A, 1
B, 1
B, 2
B, 3
C, 1
C, 2
D, 1
A, 1
B, 1
B, 2
B, 3
C, 1
C, 2
D, 1
Now use a router transformation using group condition as,
O_count=1.
Then all unique rows will go to one target and connect the default group to another table which will hold the duplicates.



Great Article
ReplyDeleteArtificial Intelligence Projects
machine learning final year projects 2020
JavaScript Training in Chennai
JavaScript Training in Chennai Project Centers in Chennai
I have read your blog its very attractive and impressive. I like it your blog. Digital Marketing Company in Chennai
Very interesting article with meaningful insights. I look forward to reading more posts from your blog.servicenow classes
ReplyDeleteGreat article! A MongoDB learning path is very helpful for beginners who want to understand NoSQL databases, CRUD operations, aggregation, and indexing. Thanks for sharing these useful insights.mongodb learning path
ReplyDeleteThis post is very helpful and easy to understand. I like how the information is explained in simple language for all readers.ab initio training
ReplyDelete