Hi, How I can test if unique values have different values in another field. Example:
Field1 Field2
AB1.... 1
AB1.... 2
AB3.... 3
AB4 ....4
AB5.... 5
AB6.... 6
AB7.... 7
AB8.... 8
So, AB1 has in field 2, values 1 and 2. So I want to filter that separately. Values can be changed, so I want generic solution. Can anyone help me with that? Thank you
Hi @gisgis2014devel
I think using a DuplicateFilter transformer on Field1 you should be able to get the desired result.
NOTE: As long as the Field Name or Attribute is same, this would work with any dataset(dynamically)
Attached fmwt file.
Using two statistics calculators and two testers will give you the result you want I think. You can do the same with multiple aggregators, matchers, or any other blocking (group by) transformer that creates a count.
Hi @gisgis2014devel
I think using a DuplicateFilter transformer on Field1 you should be able to get the desired result.
NOTE: As long as the Field Name or Attribute is same, this would work with any dataset(dynamically)
Thank you, it does what I want in a simple way.
Attached fmwt file.
Using two statistics calculators and two testers will give you the result you want I think. You can do the same with multiple aggregators, matchers, or any other blocking (group by) transformer that creates a count.
Thank you a lot 
. I will try your solution as well. Also rahulsharma solution worked well.