Alteryx Designer Desktop Discussions

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

Multi-Row Formula Tool Help

walkingonformulas
6 - Meteoroid

 

Alteryx_Help.png

Hello! I'm running into trouble here and trying to use the Multi Row Formula Tool.

 

What I'd like to do is check if the first record of the CurrentDate field (11/15/2023) matches the first record of any of the days of the week as a condition. If the dates match (In this example it would be the Wednesday field), I want to add the hours record to the second record of that field. The output should look like this:

 

Alteryx_Help_2.png

 

Thank you for the help!

3 REPLIES 3
flying008
14 - Magnetar

Hi, @walkingonformulas 

 

FYI.

 

录制_2023_11_16_08_41_07_992.gif

Qiu
20 - Arcturus
20 - Arcturus

@walkingonformulas 
IMHO,Alteryx is not really intended for this kindly of use. 😂
Anyhow, hope below will help. and I did not care the order of Data Fields, we can do something about that if you do care.

1116-benjamincunningham.png

walkingonformulas
6 - Meteoroid

Life Saver thank you for the help

Labels