Skip to main content
Solved

How to import/run multiple tests using values in a spreadsheet?

bush_walker
Contributor
Forum|alt.badge.img

Hi everyone,

 

I have a workspace where I am trying to test some element attributes to see if they match certain conditions/values. So kind of like:

 

Location: Melbourne (fixed for all elements in file)

Asset type: various (varies per element)

 

I have around 80 of these attributes to test. The tests parameters are contained in an Excel file, i.e. I have a file that has the following columns:

 

  • Attribute Name
  • Attribute value (either has a value that I want to check against if Fixed)
  • Attribute type (contains term 'fixed' or 'varies')

 

Other than writing each individual rule into the Tester, is there a more efficient way to do this, particularly as the parameter spreadsheet may update and I want to avoid re-writting all the tests?

 

Thanks in advance for your help! Amit

Best answer by markatsafe

@bush_walker​ You can sometimes use DatabaseJoiner or FeatureJoiner to do a lookup on the speadsheet. If the match fails then you know the 'element' didn't math on in your list. InlineQuerier also allows a wider range of join expressions. If you can attach a sample of the data and lookup someone could probably create a minimum working example for you

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

3 replies

redgeographics
Celebrity
Forum|alt.badge.img+49

You could try a FeatureMerger or FeatureJoiner, have it match on all those attributes. If it doesn't match, it means that feature failed all tests.

M
Forum|alt.badge.img+2
  • markatsafe
  • Best Answer
  • October 3, 2022

@bush_walker​ You can sometimes use DatabaseJoiner or FeatureJoiner to do a lookup on the speadsheet. If the match fails then you know the 'element' didn't math on in your list. InlineQuerier also allows a wider range of join expressions. If you can attach a sample of the data and lookup someone could probably create a minimum working example for you

bush_walker
Contributor
Forum|alt.badge.img
  • bush_walkerContributor
  • Author
  • Contributor
  • October 5, 2022

Thanks for your help @Hans van der Maarel​ and @Mark Stoakes​  - I used the FeatureMerger to achieve what I needed. See screenshot below, I'm testing custom IFC fields (converted from traits attributes) against a test in the Attribute Manager.

 

image

Reply


Helpful Members This Week

Community Stats

30,971
Posts
117,398
Replies
38,758
Members

Latest FME

Terms & ConditionsCookie settings

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
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.