Alteryx Designer Discussions

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

Update a Field Comparing Date field from another Dataset

DataPirate26
9 - Comet

Hello, 

 

Can someone help me to Update the Field Margin in File 1 comparing with File 2 Months Field. 

 

The logic used would be We have to check Today's Date first and then pull the Date from File 2 which is closest to Today's Date. So the date closest to days's date is 15th August 2022. So the Margin field in File 1 would be updated to 15th August 2022. 

 

Test workflow attached below. can someone help me out with a solution. 

3 REPLIES 3
grazitti_sapna
16 - Nebula

@DataPirate26, try this.

grazitti_sapna_0-1660105882234.png

 

I hope this helps!

Thanks!

Sapna Gupta
DataPirate26
9 - Comet

@grazitti_sapna Thank you for your quick resolution. I was trying to find out the difference of the days and then take the Minimum value but this is much optimised solution. 

grazitti_sapna
16 - Nebula

@DataPirate26, you're welcome. I am glad it worked for you.

 

Thanks!

Sapna Gupta
Labels