Replace the blank/Null() values with the date in the column

[nkrupabd]

Hi I'm new to Alteryx and trying to replace the Null / Blank rows with the Date value present in the New_date column, could any one please help . Thank you. Attaching an example below

[atcodedog05]

Hi @nkrupabd 

Welcome to the Alteryx Community 🙂

Can you provide some sample input and expected output it will help us get a better understanding of the usecase.

[nkrupabd]

Thank you. So what i'm actually trying to do is if paydate month and year are equal to end_date month and year ,i want it to display that pay date in a new column. Attached the input already and attaching the output below

[atcodedog05]

Hi @nkrupabd 

Here is how you can do it. I am using DateTimeFormat([Pay dates],"%Y-%m") to compare only Year and Month.

Workflow:

Hope this helps : )

[Tyro_abc]

Hi @nkrupabd 

I am not sure! Are you asking for this?

Please check and let me know.

Regards

Arundhuti

[nkrupabd]

sorry i want it to look something like this 

[atcodedog05]

Hi @nkrupabd 

Here is how you can do it. I am using append tool to add value to all rows.

https://help.alteryx.com/20213/designer/append-fields-tool 

Workflow:

Hope this helps : )

[Tyro_abc]

Hi

Check this

[nkrupabd]

Thanks a lot it helped