Subtracting Date

Mwalden11

Hey! I have this example below of an ID that has multiple values but in the Argument Name column there is a "start" and "end" date that I want to subtract. Anyone have any advice on how to do this?

ID	Argument Name	Argument Value
1097239	START	1/1/2020 18:49
1097239	n/a	n/a
1097239	n/a	n/a
1097239	n/a	n/a
1097239	n/a	n/a
1097239	n/a	n/a
1097219	END	1/1/2020 18:57

JBO

Yes. I would do the following:

1) Use the Filter tool to isolate rows that only have "START" OR "END" in the Argument Name field.

2) Use the Sort tool to sort the data in the order you want them (by ID and then Argument Value, for example).

3) Use the Multi-Row Formula tool. 

I am making some assumptions on the conditions, but here is the formula you could use:

if [ROW-1: Argument Name] = "START"

and [Argument Name] = "END"

then DateTimeDiff([Argument Value], [ROW-1: Argument Value], "minutes")

else null()

endif

4) Use the Union tool to bring the filtered rows back together again. Then use Sort tool if you want them sorted a certain way.

Note that this approach is putting the difference between values in a new field that you will need to give a field name and type.

Hope this helps. Sorry I didn't build the flow and upload.

If the ID #s are important to the condition, then you need to incorporate that into the formula. For example, if the Start ID# must be different from the end ID#, as they are in your example.