Skip to main content
Solved

Inline Querier Wildcard Matching

  • July 5, 2019
  • 2 replies
  • 36 views
dmerrick
Contributor
Forum|alt.badge.img+1

Hi,

I am trying to match a numeric string in one field with what I have in another string field.

I want to compare what I have in the [ASBUILT_NUMBER] field with the [MAP_LABEL] field but I am unable to get the Inline Query wildcard expression to work.

I have tried many different iterations of

WHERE MAP_LABEL LIKE '%ASBUILT_NUMBER%'

or where @VALUE(ASBUILT_NUMBER) or inserting the wildcards and single quotattions into the field beforehand so I can compare the value to no success.

I know it works for static comparisons (MAP_LABEL LIKE '%963%') but I have not found success otherwise.

THANKS!

Best answer by takashi

You need to concatenate character '%' and the value of "ASBULT_NUMBER" field in the where clause. e.g. 

WHERE MAP_LABEL LIKE '%'||ASBUILT_NUMBER||'%' 
    This post is closed to further activity.
    It may be an old question, an answered question, an implemented idea, or a notification-only post.
    Please check post dates before relying on any information in a question or answer.
    For follow-up or related questions, please post a new question or idea.
    If there is a genuine update to be made, please contact us and request that the post is reopened.

    2 replies

    takashi
    Celebrity
    • takashiCelebrity
    • 7843 replies
    • Best Answer
    • July 5, 2019

    You need to concatenate character '%' and the value of "ASBULT_NUMBER" field in the where clause. e.g. 

    WHERE MAP_LABEL LIKE '%'||ASBUILT_NUMBER||'%' 
    Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?
    dmerrick
    Contributor
    Forum|alt.badge.img+1
    • dmerrickContributor
    • Author
    • Contributor
    • 45 replies
    • July 5, 2019

    You need to concatenate character '%' and the value of "ASBULT_NUMBER" field in the where clause. e.g. 

    WHERE MAP_LABEL LIKE '%'||ASBUILT_NUMBER||'%' 

    Thank you!

    Community Stats

    32,080
    Posts
    121,818
    Replies
    39,714
    Members

    Latest FME

    Terms & ConditionsCookie settingsAccessibility statement
    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.