Replace Null Values

[Sarath27]

Hi All,

Could you please help me in achieving this?

I want to populate the same dates in the null rows until the new row which has date. Pls refer the screenshot attached.

Thanks,

Sarath

[ShankerV · Accepted solution]

Hi @Sarath27 

Please use the below in Multi Row formula tool.

Select Update Existing Field

Expression:

IF IsNull([Corrected Trade date])
THEN [Row-1:Corrected Trade date]
ELSE [Corrected Trade date]
ENDIF

Many thanks

Shanker V

[Sarath27]

Thank you so much! It works well.

[snadeau456]

Hi, can you help?

If the cell in the flag column is Null, then in the comments column, Alteryx is to add remove from 12219, else leave it blank.

If (Null([FLAG_CD])
Then([Comments] "remove from 12219")
Else ""
ENDIF