I am trying to combine the STB field by date, but if there is another event within +-1 day, I would like to group those STB into the first date. My results look like this:
LAST_REPORT_DATE STB TEL count
1/31/2016 160767276 5551234567 4
160987956
161689512
M91542SI9196
1/21/2016 M91151EJ4964 5551234567 3
M91151EJ4980
M91151EJ4992
1/22/2016 M91148FA0104 5551234567 1
I'm trying to get it to look like this
LAST_REPORT_DATE STB TEL count
1/31/2016 160767276 5551234567 4
160987956
161689512
M91542SI9196
1/21/2016 M91151EJ4964 5551234567 4
M91151EJ4980
M91151EJ4992
M91148FA0104
... View more