Skip to main content
Question

Tester query


Forum|alt.badge.img
Hi (again),

 

 

I am running a workbench with a simple Tester that isn't giving the desired results.  I have a published parameter set to a value "00MF" and the same value exisits 128 out of 500 times in a .csv file (no other columns).  I have set up a test that compares these two attributes called EQ_Query_LA and Origin_LA but I get no matches.  I've attached a screenshot below.  I'm sure it's really simple, but I  can't put my finger on it!

 

 

I've tried it with values that are only numbers or only text and changing the mode.

 

 

 

 

Grateful for any answers!

12 replies

Forum|alt.badge.img
  • Author
  • February 28, 2013
Link to image:

 

 

http://dl.dropbox.com/u/7141908/TesterWorkspace.png

david_r
Celebrity
  • February 28, 2013
Some things to try:

 

  • Set the test clause mode to "String"
  • Try inserting an AttributeTrimmer first
  • Make sure that the values to compare have the same case

 


Forum|alt.badge.img
  • Author
  • February 28, 2013
Hi Dave,

 

 

Thanks for the reply.

 

 

I tried all of the above, all 500 csv entries and the parameter fail, i.e. 501 fails.

 

  • Tester set to string
  • Inserted 2 x CaseChanger (set to Uppercase)
  • Inserted 2 x AttributeTrimmer (Trim type:Both & Trim Characters: blank) 

 


david_r
Celebrity
  • February 28, 2013
For me, the next logical step would be to insert inspection points just before the Tester to make a visual check of the parameter values entering the transformer.

 

 

David

Forum|alt.badge.img
  • Author
  • February 28, 2013
OK, I've given that a spin and I get the results below (not resolved).  I'm completely stumped!

 

 

First inspection point:

 

http://dl.dropbox.com/u/7141908/TesterWorkspaceIP1.png

 

 

Second inspection point:

 

http://dl.dropbox.com/u/7141908/TesterWorkspaceIP2.png

 

 

Tester Parameters

 

http://dl.dropbox.com/u/7141908/TesterWorkspaceTesterParameters.png

 

 

(p.s. I just noticed the _ in front of one of the attributes which I've removed, it hasn't been causing the problem. 

 

 

Thanks.

david_r
Celebrity
  • February 28, 2013
Try using the operator "LIKE" and see what happens.

 

 

David

Forum|alt.badge.img
  • Author
  • February 28, 2013
Thanks for the reply, I did try a few different operands, have gone through them again:

 

  • Like: 501 fails
  • Contains 500 pass, 1 fail
  • Begins with: 500 pass, 1 fail
  • Ends with: 500 pass, 1 fail 
  • In: 501 fails  
Still no joy unfortunately.

dustin
Influencer
Forum|alt.badge.img+31
  • Influencer
  • February 28, 2013
Try using the TestFilter instead of the Tester.

  • February 28, 2013
I tried to use a published user parameter in a Tester transformer in FME2013. It worked as expected. FME uses the following syntax to refer to the value of a parameter:

 

  $(ParameterName)

 

 

 

Try the following text in the "Test Clauses"."Left Value" (of the tester parameter disalog):

 

    $(Param_EQ_Query_LA)

 

 

Good Luck!

  • February 28, 2013
I have tried to use a published user parameter in the tester transformer in FME2013. It worked as expected. The syntax used: $(ParameterName)

 

 

So you may enter the following text in Tester parameters dialog:

 

  $(Param_EQ_Query_LA)

 

 

Good Luck!

Forum|alt.badge.img
  • Author
  • March 4, 2013
Thanks byjukp!!  It now works!  It looks like the Tester doesn't work unless the Attribute is explicity exposed as a Parameter as per your post.  I'll feed it back to Safe.  Got there in the end! 

 

 

Thanks again everyone.

gio
Contributor
Forum|alt.badge.img+15
  • Contributor
  • September 11, 2013
tho an old issue, i find it amazing.

 

As, at leat in 2012 u can simply choose the parameter in the dropdownlist.

 

U dont even need to fetch it.

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