In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities
here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started.
Learn more here
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED
Hello,
I use the multirow-formular. I want to flag every Timestamp that has a other timestamp before or after with the (time)difference of 15 minutes.
now my probleme is that the first and the last row always gets flaged because there is no row-1 (for the first) and no row+1 (for the last).
How can i improve the formular that for the first timestamp only row+1 is used and for the last only row-1. Is this possible?
Solved! Go to Solution.
Hey @df
You could add an extra contidion to your formula to say AND !IsNull([ROW+1:TimeStampDateTime])/AND !IsNull([ROW-1:TimeStampDateTime])
You will need to change your multirow formula to be NULL for Values that don't exist.
Part time Tableau, Part Time Alteryx. Full Time Awesome
