Workflow Help

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.

data cleanse.yxzp

Datasets

Preparation

Accepted answers

All comments

binu_acs

@ManuelRodrigues

data cleanse (1).yxmd

ManuelRodrigues

@binu_acs 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?

binu_acs

@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

@binu_acs 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

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

binu_acs

@ManuelRodrigues

data cleanse (1).yxmd

binu_acs

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15874

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703