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
Best answer by rahulsharma
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)
+10Hi @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)
+2Attached 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.
