Skip to main content
Question

Testing the existence and absence of values

  • October 2, 2020
  • 1 reply
  • 27 views

I have two tables - the first lists a series of attributes and values against equipment

Image1

And the second lists the expected attributes that should be listed against each equipment type

Image2

I need a way of telling which are present, but more importantly which are not. So in this example

Equipment 5 is complete

Equipment 10 is missing Sum

Equipment 15 is missing Count

 

Ultimately I need to get a score

Sample 100% exists

Sum 0% exists

Count 50% exists

 

The bit i'm really struggling with is the absence of things since the equipment table is huge and the requirements differ for each equipmenttype

 

Thanks for your help

1 reply

  • Author
  • October 2, 2020

Stepping way from things always helps an idea to pop into your mind..

 

Think this does it

Answered

  1. It starts off with a sampler and statisticscalculator. these work out how many of each Equipment Types I have
  2. This is FeatureMerged with the table of required attribute names to work out how many of each attribute there should be in my equipment table
  3. A StatisticsCalculator works out how many there actually are
  4. The two are featuremerged together where equipmenttype and attributename match
  5. An attributemanager updated any unmatched with a count 0 since it is not present
  6. An expressionevaluator calculates the difference to give me a % present

Reply


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