Skip to main content
Solved

populate cell from the value in the cell above


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

hussainalimalik wrote:

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
Did this help you find an answer to your question?

4 replies

ebygomm
Influencer
Forum|alt.badge.img+31
  • 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

 


ebygomm wrote:

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+31
  • Influencer
  • Best Answer
  • March 25, 2021
hussainalimalik wrote:

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


hussainalimalik wrote:

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings