Testing the existence and absence of values

Question

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

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

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

har40428 · Answer

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

Think this does it

Answered

It starts off with a sampler and statisticscalculator. these work out how many of each Equipment Types I have
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
A StatisticsCalculator works out how many there actually are
The two are featuremerged together where equipmenttype and attributename match
An attributemanager updated any unmatched with a count 0 since it is not present
An expressionevaluator calculates the difference to give me a % present

Sign up