Change column for the specific rows

[Neffri]

Is it possible to change Universe Date to add 2023-12-31 only where we have Max of column As of Date and leave the rest unchanged?

[RolandSchubert · Accepted solution]

Hi @Neffri ,

select the MAX date after converting "As of Date" to date data type and replace then. I've attached a sample workflow.

Let me know if it works for you.

Best,

Roland