SOLVED
Replace Null Values
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Sarath27
8 - Asteroid
‎09-01-2023
02:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
Labels:
- Labels:
- Transformation
3 REPLIES 3
ShankerV
17 - Castor
‎09-01-2023
02:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
‎09-01-2023
10:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you so much! It works well.
snadeau456
8 - Asteroid
‎03-26-2024
02:14 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
![](/skins/images/12DF86F0CA96E81F3ABF675C1590B6DD/responsive_peak/images/icon_anonymous_message.png)