I'm working on a workflow that gives me a bit of insight into the time our workflows take to run. all the data and stuff is extracted thanks to Alteryx but i run into a problem because I need to do some calculations now row by row but with multiple rows in mind. When I use the multi row formula tool I was expecting an other output. Formula I use within the tool. IF [WF] == [Row-1:WF] THEN [Row-1:StartTime] ELSE DateTimeadd([StartTime],[TimeDifferance],"Seconds") ENDIF I've attached a table below with the results I get when running the data via Alteryx and I calculated the the expected output via Excel to verify the output. I think my formula is wrong WFTimeStartTimeTimeDifferanceStartTime ExpectedStartTime before entering multi-row formulaWorkflow10:01:1216/07/2022 21:30:107216/07/2022 21:30:1016/07/2022 21:30:10Workflow10:01:1216/07/2022 21:30:107216/07/2022 21:30:1016/07/2022 21:30:10Workflow 50:18:1016/07/2022 21:48:20109016/07/2022 21:31:2216/07/2022 21:30:10Workflow 50:18:1016/07/2022 21:48:20109016/07/2022 21:31:2216/07/2022 21:30:10Workflow 50:18:1016/07/2022 21:48:20109016/07/2022 21:31:2216/07/2022 21:30:10Workflow 50:18:1016/07/2022 21:48:20109016/07/2022 21:31:2216/07/2022 21:30:10Workflow 50:18:1016/07/2022 21:48:20109016/07/2022 21:31:2216/07/2022 21:30:10Workflow 50:18:1016/07/2022 21:48:20109016/07/2022 21:31:2216/07/2022 21:30:10Workflow 50:18:1016/07/2022 21:48:20109016/07/2022 21:31:2216/07/2022 21:30:10Worklfow 120:00:1316/07/2022 21:30:231316/07/2022 21:49:3216/07/2022 21:30:10Worklfow 120:00:1316/07/2022 21:30:231316/07/2022 21:49:3216/07/2022 21:30:10Workflow 140:01:4216/07/2022 21:31:5210216/07/2022 21:49:4416/07/2022 21:30:10Workflow 140:01:4216/07/2022 21:31:5210216/07/2022 21:49:4416/07/2022 21:30:10Workflow 200:01:3916/07/2022 21:31:499916/07/2022 21:51:2616/07/2022 21:30:10Workflow 200:01:3916/07/2022 21:31:499916/07/2022 21:51:2616/07/2022 21:30:10

Working with Muli-Row formula unexpected result

I'm working on a workflow that gives me a bit of insight into the time our workflows take to run.

all the data and stuff is extracted thanks to Alteryx but i run into a problem because I need to do some calculations now row by row but with multiple rows in mind.

When I use the multi row formula tool I was expecting an other output.

Formula I use within the tool.

IF [WF] == [Row-1:WF] 

   THEN [Row-1:StartTime] 

   ELSE DateTimeadd([StartTime],[TimeDifferance],"Seconds")

ENDIF

I've attached a table below with the results I get when running the data via Alteryx and I calculated the the expected output via Excel to verify the output.

I think my formula is wrong

WF	Time	StartTime	TimeDifferance	StartTime Expected	StartTime before entering multi-row formula
Workflow1	0:01:12	16/07/2022 21:30:10	72	16/07/2022 21:30:10	16/07/2022 21:30:10
Workflow1	0:01:12	16/07/2022 21:30:10	72	16/07/2022 21:30:10	16/07/2022 21:30:10
Workflow 5	0:18:10	16/07/2022 21:48:20	1090	16/07/2022 21:31:22	16/07/2022 21:30:10
Workflow 5	0:18:10	16/07/2022 21:48:20	1090	16/07/2022 21:31:22	16/07/2022 21:30:10
Workflow 5	0:18:10	16/07/2022 21:48:20	1090	16/07/2022 21:31:22	16/07/2022 21:30:10
Workflow 5	0:18:10	16/07/2022 21:48:20	1090	16/07/2022 21:31:22	16/07/2022 21:30:10
Workflow 5	0:18:10	16/07/2022 21:48:20	1090	16/07/2022 21:31:22	16/07/2022 21:30:10
Workflow 5	0:18:10	16/07/2022 21:48:20	1090	16/07/2022 21:31:22	16/07/2022 21:30:10
Workflow 5	0:18:10	16/07/2022 21:48:20	1090	16/07/2022 21:31:22	16/07/2022 21:30:10
Worklfow 12	0:00:13	16/07/2022 21:30:23	13	16/07/2022 21:49:32	16/07/2022 21:30:10
Worklfow 12	0:00:13	16/07/2022 21:30:23	13	16/07/2022 21:49:32	16/07/2022 21:30:10
Workflow 14	0:01:42	16/07/2022 21:31:52	102	16/07/2022 21:49:44	16/07/2022 21:30:10
Workflow 14	0:01:42	16/07/2022 21:31:52	102	16/07/2022 21:49:44	16/07/2022 21:30:10
Workflow 20	0:01:39	16/07/2022 21:31:49	99	16/07/2022 21:51:26	16/07/2022 21:30:10
Workflow 20	0:01:39	16/07/2022 21:31:49	99	16/07/2022 21:51:26	16/07/2022 21:30:10

Datasets

Designer Cloud

Transformation

Accepted answers

All comments

ChrisTX

Can you post a screenshot of your Multi Row tool? Did you check the box to group by WF?

Chris

IraWatt

Hey @MartWClimber,

First thing I did was convert your text Start Time to a date time using the Date Time Tool. Then I applied your formula to the new date time column:

This gave the correct results 2022-07-16 21:48:20 + 1080 seconds is 2022-07-16 22:06:30 not 16/07/2022 21:31:22.

Any questions or issues please ask
HTH!
Ira

Workflow.yxmd

binu_acs

@MartWClimber one way of doing this using the DateTimeParse function

Dat_Update_18_07.yxmd

MartWClimber

I've updated the post with a screenshot.

also I tried group by the WF but that didn't work

MartWClimber

@binu_acs not quite because if you take a look at the new output (I think you created) I see that there is a row that contains that timestamp 21:31:22 that is correct in the sense that the starttime + 1:12 minutes equals this but the location is wrong. I would expect that timestamp to be in row 3 not in row 1