+2Hi. I have a FGDB (esri) with coded value. I've tester for field (HorizontalAccuracy). This field must be in some value (Low, High, Medium).
I use in for operator but it doesn't work. I've try so with coded value. Can you help me please, I use FME 2018, i don't have cachedvalue :(
Best answer by tomf
I'v try this and it's dond't work !
I realise @Mark Stoakes has answered this, but for the sake of completeness in this answer the reason your IN clause was not working was due to the spaces after each comma.
FME is searching for values that match, e.g., " High (=<10cm)" and not "High (=<10cm)" (my quotes)
Removing those spaces will produce the right results.
@hugues You have to enclose values that contain a hyphen "-" in quotes - see user documentation on TestFilter Test Clause Operators. Hyphen is used as a range in the IN, i.e. 1-9 or a-z. So in your case you can use:
High (=<10cm),Low (>= 1m),"Medium (10cm - 1m)"
+2@hugues You have to enclose values that contain a hyphen "-" in quotes - see user documentation on TestFilter Test Clause Operators. Hyphen is used as a range in the IN, i.e. 1-9 or a-z. So in your case you can use:
High (=<10cm),Low (>= 1m),"Medium (10cm - 1m)"
+2@hugues You have to enclose values that contain a hyphen "-" in quotes - see user documentation on TestFilter Test Clause Operators. Hyphen is used as a range in the IN, i.e. 1-9 or a-z. So in your case you can use:
High (=<10cm),Low (>= 1m),"Medium (10cm - 1m)"
I'v try this and it's dond't work !
@hugues I've attached an example workspace (FME 2020). Perhaps you can use that to reproduce the issue you've encountered.
AttributeValidator might also be an alternative as it gives you more granularity over the tests.
+20I'v try this and it's dond't work !
I realise @Mark Stoakes has answered this, but for the sake of completeness in this answer the reason your IN clause was not working was due to the spaces after each comma.
FME is searching for values that match, e.g., " High (=<10cm)" and not "High (=<10cm)" (my quotes)
Removing those spaces will produce the right results.
