Skip to main content
  • EN
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!
Link to image:

 

 

http://dl.dropbox.com/u/7141908/TesterWorkspace.png
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

 

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) 

 

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
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.
Try using the operator "LIKE" and see what happens.

 

 

David
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.
Try using the TestFilter instead of the Tester.
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!
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!
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.
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.

Reply


Community Stats

30,096
Posts
114,255
Replies
37,726
Members
Terms & ConditionsCookie 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.