Hi
i have a dataset where there could some duplicates
if the name and date matches then put a 0 in that row (only duplicated row)
eg
DateTime, Name, Location, Time, Time2, Subject, Time3
27/07/2020 09:00, Simon, London, 03:50:00, 01:00:00, English, 02:00:00
27/07/2020 09:00, Simon, Liverpool , 03:50:00, 01:00:00, English, 02:00:00
The data should in that example look like this
27/07/2020 09:00, Simon, London, 03:50:00, 01:00:00, English, 02:00:00
27/07/2020 09:00, Simon, Liverpool , 0, 0, English, 0
Hope this makes sense
i have a dataset where there could some duplicates
if the name and date matches then put a 0 in that row (only duplicated row)
eg
DateTime, Name, Location, Time, Time2, Subject, Time3
27/07/2020 09:00, Simon, London, 03:50:00, 01:00:00, English, 02:00:00
27/07/2020 09:00, Simon, Liverpool , 03:50:00, 01:00:00, English, 02:00:00
The data should in that example look like this
27/07/2020 09:00, Simon, London, 03:50:00, 01:00:00, English, 02:00:00
27/07/2020 09:00, Simon, Liverpool , 0, 0, English, 0
Hope this makes sense