Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Between the dates

Scheruku
8 - Asteroid

Hi All,

 

We have challan and entry date for the vehicles.. We are trying to find out if the same vehicle has entered again (entry time) between the challan and entry time.

 

For ex - the vechicle has challan time of 20-07-2018 and entry time of 25-07-2018, and for the same vehicle do we have entry time between the dates, like 21-07-2018 which should not happen...

 

VehChallan Entry 
1234505-07-201707-10-2017 
1234506-07-201706-07-2017Flag
1678202-07-201705-07-2017 
1678205-07-201705-07-2017 
1678205-07-201704-07-2017flag
1678212-07-201713-07-2017 

 

 

Best Regards,

4 REPLIES 4
vishwa_0308
11 - Bolide

Hi @Scheruku,

 

For each vehicle everytime the Entry Date will be greater in the next row. Here is the formula:

In Multi-row formula tool use below formula grouping by vehicle.

if [Entry]>=[Row-1:Entry] then "" else "Flag" endif

 

Thanks,

Vishwa

 

 

mceleavey
17 - Castor
17 - Castor

Hi @Scheruku,

 

I've built a workflow that does it for you.

Let me know if it works.

 

M.



Bulien

Scheruku
8 - Asteroid

Hi @mceleavey,

 

Thank you for your help... I was able to run the workflow but it wasn't throwing me the exeptions..for example

 

Row No 6 has an entry date of dd-mm-yyyy(07-01-2018) but the same vehicle has an entry date prior to it on the above rows... We are saying the vehicle has prior date because it falls between challan and entry time of the that particular row

 

challan - 23-09-2017 Entry 07-01-2018

 

The above row has an entry date between these two dates i.e, 05 & 01 ...and these two rows have to be flagged  

 

VehChallanEntry
B893329-07-201730-07-2017
B893326-12-201727-12-2017
B893330-12-201731-12-2017
B893302-01-201802-01-2018
B893304-01-201805-01-2018
B893323-09-201707-01-2018
B893308-01-201809-01-2018
danrh
13 - Pulsar

Does something like this do the trick?

image.png

Labels