Skip to main content
Solved

populate cell from the value in the cell above

  • Mar 25, 2021 12:53 PM UTC
  • 4 replies
  • 188 views

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

View original
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
Evangelist
Forum|alt.badge.img+54
  • Evangelist
  • Mar 25, 2021 2:39 PM UTC

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

 


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
Evangelist
Forum|alt.badge.img+54
  • Evangelist
  • Best Answer
  • Mar 25, 2021 5:57 PM UTC

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


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