Formula help for data cleanse

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!

Station Sample.xlsx

Datasets

Expression

Accepted answers

All comments

saveeshkumar

Hi @ManuelRodrigues ,

Hope this help you.

Thanks.

data cleanse.yxmd

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.

Station Sample.xlsx

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!

Station Sample.xlsx

saveeshkumar

Hi @ManuelRodrigues ,

Please find the updated logic.

Thanks

data cleanse.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15874

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703