The sample data is for 01 Jan 2017. The ID number 2021333262 ride a shuttle twice on that day that is why there are two "Inbound" data. He has a record of 1,050.11 for 01 Jan 2017, however, this figure should only appear once and not double. What should we do in order to only have one record of 1,050.11 but still there will be two inbound data? Thank you so much.
Hi, thanks for the reply. Yeah, I reviewed the data we're using and there is a particular field that makes the value duplicate. All clear to us and the data itself needs to be cleansed first. Thanks again!