How create the change turn with alteryx ?

Hi all,

I've created manually with excel a simulation of change turn. In the table TK indicate the
change of means of transport. How can I replicate the same view with Alteryx please?

Note that the part underlined doesn't exist, but that's what I want to get.

Is there someone that can help me please ?

Thanks a lot.

Andrea

Shift.csv

Transformation

Batch Macro

Behavior Analysis

Accepted answers

TonyA

I think I understand. You are scheduling some kind of transportation. Transport 1 leaves station A at 12:05AM, travels to T and returns at 10:20. It is then available for the next run which leaves at 11:35. In the meantime six other vehicles leave on other runs. I built the attached workflow that calculates this using an iterative macro but I'm getting slightly different results. You have vehicle 2 leaving on a run at Row 8 that returns at 14:40, but you have it going out again at 12:30. If I understand the problem correctly, it is leaving on another run before it has returned. Please let me know if I'm missing something.

EDIT: By the way, if you want to allow for loading/unloading time between runs, you can change "0" in the first Multi-Row Formula tool in the macro to a number that represents the number of minutes for the layover. For example,

IF IsNull([Row-1:LatestArrival]) OR DateTimeDiff([Dept Time],[Row-1:LatestArrival],"minutes") > 20
THEN [Arvl Time2]
ELSE [Row-1:LatestArrival]
ENDIF

would allow for a 20 minute layover before the next run.

Change Turns.yxzp

All comments

Andrea92

Any suggestion please ?

Jonathan-Sherman

Hi @Andrea92,

Which columns are you trying to recreate? And what would be an example of one of the identifiers?

Regards,

Jonathan

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703