Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

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

nkrupabd
8 - Asteroid

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
22 - Nova
22 - Nova

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
8 - Asteroid

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
22 - Nova
22 - Nova

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
8 - Asteroid

sorry i want it to look something like this 

nkrupabd_1-1632145393261.png

 

 

atcodedog05
22 - Nova
22 - Nova

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
8 - Asteroid

Thanks a lot it helped

 

Labels