Skip to main content
Solved

Select Records in single table and add value to other field

  • December 1, 2022
  • 1 reply
  • 58 views
vxn43
Supporter
Forum|alt.badge.img+18

I have a single table, TABLE1. I have a field named STE. I would like to select the values of STE that are NOT NULL, then add the selected values in STE to the ADDR field in same table.

 

What is the most suitable transformer(s) to go about doing this?

Best answer by dustin

Several ways to accomplish, but I normally use an AttributeManager with a conditional value. The test condition will be testing SDE for not null, if so, set the attribute value to SDE. Otherwise, no action.

image

    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.

    1 reply

    dustin
    Influencer
    Forum|alt.badge.img+31
    • dustinInfluencer
    • Influencer
    • 627 replies
    • Best Answer
    • December 1, 2022

    Several ways to accomplish, but I normally use an AttributeManager with a conditional value. The test condition will be testing SDE for not null, if so, set the attribute value to SDE. Otherwise, no action.

    image

    Community Stats

    32,066
    Posts
    121,745
    Replies
    39,692
    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.