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:
Thank you for the help!
Solved! Go to Solution.
@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.
Life Saver thank you for the help