Multi-row formula issue

Hi all,

New to altteryx!

In my workflow, I convert date (string) to DateTime using the DateTime tool. Then,

I have the following multi-row formula:

However, this is what I get for the new column:

As you can see, this is not behaving as expected; e.g. the difference between the third and fourth row should be 6 minutes = 360 seconds, but it reports 60. Could you please let me know what could be wrong?

The purpose of the new column is to group the rows together that are close to each other (i.e. that dont differ by more than 60 seconds)

Thanks

Workflow

Parse

Date Time

Accepted answers

bmcclelland46

Good news! Think I have what you are looking for. Please see the attached workflows (attached a workflow zip and regular workflow in case you had trouble with either.) Let me know if you have any questions and please mark this as solved if I helped.

hamzam help.yxmd

hamzam help.yxzp

All comments

bmcclelland46

I think there are a couple things you can try. If this data is sorted, you should never have a negative time popping up- try flipping the dt1 and dt2 variables (Row+1:x,x,”seconds”) and make sure that the data type is large enough to hold the number of seconds- try double or int64. If you are still getting a weird answer, try alternating the rows 1,2,1,2 and create a cross tab so you can just use a typical formula tool and you can always pivot the fields back. Let me know if that helps!

hamzam

Hi,

the data is not sorted. I changed it from int32 to int64, but same results. Could you expand on what you mean by "alternating the rows 1,2,1,2..."?

thank you

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703