Community Halloween is live until October 31st! Complete any 2 quick activities to earn the 2025 Community Halloween badge. Feeling brave? Check out the activities here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Multi-row tool returning null values in place of calculated values

MHS
8 - Asteroid

Hello Community!

 

I am running into what seems to be a rather simple fix, but have been unable to resolve it on my end.  I am using a series of multi row tools to measure the duration between timestamps and instead of getting the calculated value, it is returning nulls?  I have tried changing the format of the data and the outputs without any success.  If anyone happens to know a solution it would be greatly appreciated.

 

Thanks and let me know if you have any questions.

 

Matt

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @MHS 

 

Change it to proper alteryx dateformat like below.

atcodedog05_0-1644603950769.png

 

Hope this helps : )

 

MHS
8 - Asteroid

Thank you atcodedog05!

 

I knew it would be something simple that I was overlooking.

 

Have a good day!

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @MHS 

Cheers and have a nice day!

Labels
Top Solution Authors