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+39
  • 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+39
  • 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


Reply


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