Workflow Help

[ManuelRodrigues]

Hi All,

I have a workflow attached but i am struggling to get the same outputs from the workflow compared by doing this manually in excel. Please see the Output and Excluded tab in excel to see what i am looking to achieve.

Logics (Manual):

1. Filter [Destination} = London

2. Look through [Originating City] & [Destination] if the two  have London in both fields then look at the [Travel/Claim Start Date] 

3. If [Travel/Claim Start Date] has the same dates either in Row+1 or Row-1 and [Originating City] & [Destination] =London in both fields then i want to exclude this.

I hope this makes sense and thanks in advance for any help provided.

[binuacs]

@ManuelRodrigues 

[ManuelRodrigues]

@binuacs  i tried to match the True Anchor at the end of the filter tool (at the end) and it does not seem to match the excluded tab in the excel file?

[binuacs]

@ManuelRodrigues I was implementing the logic mentioned above . Can you explain why the below record should be excluded?

Data Source	Employee Number/Name	Ticket Type	Travel/Claim Start Date	Originating City	Destination/Location	Nights
Rail Data	10003896 Jane Heath	Other	17/02/2020	Bicester Town	London	0
Rail Data	10003896 Jane Heath	Anytime	10/03/2020	Bicester Town	London	0
Rail Data	10003896 Jane Heath	Off-Peak	10/03/2020	London	London	0

[ManuelRodrigues]

@binuacs please see below:

I have only used one example here but if you review the excel file it will show the pattern and manual logic i am following.

[ManuelRodrigues]

@binuacs apologies if this was unclear initially but if there is any clarity you need on my manual logic pls let me know?

[binuacs]

@ManuelRodrigues 

[binuacs]

@ManuelRodrigues Just wanted to confirm whether the above workflow works for you or not?