Home Data Prep Q&A

Paxata Community Members: Something special in a community experience is coming your way. Stay tuned to this space.
In the meantime, check out the brand new Data Prep for Data Science topic here and the new DataRobot Community.

Visit the official Paxata Documentation portal for all of your doc needs.

Fill Down, IF...

When using the Fill Down function, is there a way to limit it to filling ONLY when a prior record in another column is equal? For example, if a current record is blank in Column B, fill down from the prior record ONLY IF the Column A of the Current Record equals Column A of the Prior record.

Answers

  • AkshayAkshay Posts: 110 admin
    Hello StrobelJones,

    Are you looking for something like this?


    if yes, then you would have to sort the columns by COLUMN and then do a fill down on Column(1). if this is not what you are looking for, could you please elaborate on your example?

    Thank You,
    Akshay
Sign In or Register to comment.