Skip to main content
Solved

Populate row based on value in previous row, when new value encountered use that value for following rows. Currently trying AttributeManager

  • October 6, 2017
  • 2 replies
  • 265 views

I'm doing this via PostGres table, but attached is a small example of some of my data in excel. Also attached are my transformers. I'm trying this via AttributeManager using an expression. Not sure if my syntax is just wrong or if my approach needs work also.

Question: When I encounter a null value I want to use the value from the previous row. I want to accomplish this for all rows until I hit a new value. Then when I hit that new value I want to use that new value in the null rows underneath it. I want to do this until the end of file. I have several thousand records like this. Reference the well_location column to see what I'm describing. Thanks for any help!

Best answer by fmelizard

17650-am.fmw Hi @bggart I think you've just got the syntax a bit wrong. Please see the attached workspace.

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.

2 replies

fmelizard
Safer
Forum|alt.badge.img+20
  • Safer
  • 3719 replies
  • Best Answer
  • October 6, 2017

17650-am.fmw Hi @bggart I think you've just got the syntax a bit wrong. Please see the attached workspace.


  • Author
  • 1 reply
  • October 26, 2017

Thank you Dan for your answer on this. It is working for me.