Skip to main content
Solved

populate cell from the value in the cell above

  • March 25, 2021
  • 4 replies
  • 129 views
H

I am working with a feature class and I have got some empty cells that share the same Structure ID, I want to fill the missing Archetype value from a value in the above row.

logic can also be created using an index column such as :

it looks simple but I have already spent hours figuring this out but couldn't find the solution. Capture1Please check the data attached to this post.

Thanks in advance

H

Best answer by ebygomm

Thanks @ebygomm​ 

I have tried this method but i am having issues with creating the correct logic, would you be able to help me create a logic based on my data

Thanks

 

This logic should work

Test if Archtype has a value, if it does, do nothing (<No Action>). Otherwise, use the Archtype value from the record above (feature[-1].Archetype)

Capture

1 Attachments
    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.

    4 replies

    ebygomm
    Influencer
    Forum|alt.badge.img+46
    • ebygommInfluencer
    • Influencer
    • March 25, 2021

    The answer here might help you figure this out

    https://community.safe.com/s/question/0D54Q00008WIfv8SAD/create-a-column-with-values-from-another-column

    If not I can provide a more detailed answer based on your sample data

     

    H

    The answer here might help you figure this out

    https://community.safe.com/s/question/0D54Q00008WIfv8SAD/create-a-column-with-values-from-another-column

    If not I can provide a more detailed answer based on your sample data

     

    Thanks @ebygomm​ 

    I have tried this method but i am having issues with creating the correct logic, would you be able to help me create a logic based on my data

    Thanks

     

    ebygomm
    Influencer
    Forum|alt.badge.img+46
    • ebygommInfluencer
    • Influencer
    • Best Answer
    • March 25, 2021

    Thanks @ebygomm​ 

    I have tried this method but i am having issues with creating the correct logic, would you be able to help me create a logic based on my data

    Thanks

     

    This logic should work

    Test if Archtype has a value, if it does, do nothing (<No Action>). Otherwise, use the Archtype value from the record above (feature[-1].Archetype)

    Capture

    H

    Thanks @ebygomm​ 

    I have tried this method but i am having issues with creating the correct logic, would you be able to help me create a logic based on my data

    Thanks

     

    @ebygomm​ 

    Sorry for the late reply.

    This logic worked like a charm.

    Many Thanks

    Community Stats

    32,154
    Posts
    122,047
    Replies
    39,812
    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.