Skip to main content
Solved

Testing if unique values have different values in another field.

  • January 11, 2021
  • 4 replies
  • 114 views

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.

DuplicateFilterNOTE: As long as the Field Name or Attribute is same, this would work with any dataset(dynamically)

View original
Did this help you find an answer to your question?

4 replies

rahulsharma
Safer
Forum|alt.badge.img+10
  • Safer
  • Best Answer
  • January 11, 2021

Hi @gisgis2014devel​ 

I think using a DuplicateFilter transformer on Field1 you should be able to get the desired result.

DuplicateFilterNOTE: As long as the Field Name or Attribute is same, this would work with any dataset(dynamically)


Forum|alt.badge.img+2

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.

 

Capture


rahulsharma wrote:

Hi @gisgis2014devel​ 

I think using a DuplicateFilter transformer on Field1 you should be able to get the desired result.

DuplicateFilterNOTE: 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.


jlbaker2779 wrote:

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.

 

Capture

Thank you a lot :). I will try your solution as well. Also rahulsharma solution worked well.

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings