Formula help for data cleanse

[ManuelRodrigues]

Hi all,

I have some data where i want to Remove London to London journey where the journey is on the same day either into or out of London (orange rows). But leave them in if they are on a different date, say someone came on Monday, then travel around London during week(green rows). Thanks In advance!

M

[saveeshkumar]

Hi @ManuelRodrigues ,

Hope this help you.

Thanks.

[ManuelRodrigues]

@saveeshkumar this seems to be removing the incorrect rows?

[saveeshkumar]

Hi @ManuelRodrigues ,

Could you please share the output of the file.

Thanks.

[ManuelRodrigues]

@saveeshkumar  data outputs and excluded data attached.

[saveeshkumar]

Hi @ManuelRodrigues ,

what about the below records.
They have same date and in/out as london.

Rail Data	10104205 Gary Reid	Anytime	08-12-2020	London	London
Rail Data	10104205 Gary Reid	Anytime	08-12-2020	London	London
Rail Data	10104205 Gary Reid	Anytime	14-12-2020	London	London
Rail Data	10104205 Gary Reid	Anytime	14-12-2020	London	London

Thanks.

[ManuelRodrigues]

@saveeshkumar  those need to be included. so the logic should be:

If they travel fro Point X to London on say 07/12/2020

and then they also travel from a London to London Station on the same day i.e. 07/12/2020 then exclude the London-London travel on 07/12/2020. My apologies i prob did not explain it well earlier. 

so in effect we should only see one line being excluded i.e. London-London travel on 07/12/2020 (sorry i made a mistake on the earlier attached file. I have reattached. Thanks in adv!

[saveeshkumar]

Hi @ManuelRodrigues ,

Please find the updated logic.

Thanks