Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

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

nkrupabd
7 - Meteor

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

8 REPLIES 8
atcodedog05
21 - Polaris

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
7 - Meteor

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
21 - Polaris

Hi @nkrupabd 

 

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

Workflow:

atcodedog05_0-1632144894999.png

 

Hope this helps : )

Tyro_abc
11 - Bolide

Hi @nkrupabd 

I am not sure! Are you asking for this?

Tyro_abc_0-1632144930708.png

Please check and let me know.

 

Regards

Arundhuti

nkrupabd
7 - Meteor

sorry i want it to look something like this 

nkrupabd_1-1632145393261.png

 

 

atcodedog05
21 - Polaris

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:

atcodedog05_0-1632145560068.png

 

Hope this helps : )

 

Tyro_abc
11 - Bolide

Hi

Check this

Tyro_abc_0-1632146037813.png

 

nkrupabd
7 - Meteor

Thanks a lot it helped

 

Labels