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
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.
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
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 : )
I am not sure! Are you asking for this?
Please check and let me know.
Regards
Arundhuti
sorry i want it to look something like this
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:
Hi
Check this
