Spreadsheet: 684418d1593354420-combining-data-from-multiple-sheets-test
Sheet: CXS

Date | Date Identifier | EMP ID | Name | Support Cat | CCR Loyalty | CSAT Survey Count | CSAT Count | NPS Survey Count | Promoter Count | QMSessionID
2020-06-02 00:00:00 | 4496335-060220 | 4496335 | Gabby Pineda Calderon | [NAME] | 2 | 1 | 0 | 1 | 0
2020-06-03 00:00:00 | 4496335-060320 | 4496335 | Gabby Pineda Calderon | [NAME] | 1 | 1 | 0 | 1 | 0
2020-06-11 00:00:00 | 4496335-061120 | 4496335 | Gabby Pineda Calderon | [NAME] | 3 | 1 | 0 | 1 | 1 |  | This was perfectly done without issues and duplicates
2020-06-12 00:00:00 | 4496335-061220 | 4496335 | Gabby Pineda Calderon | [NAME] | 5 | 1 | 1 | 1 | 0
2020-06-17 00:00:00 | 4496335-061720 | 4496335 | Gabby Pineda Calderon | [NAME] | 1 | 1 | 0 | 1 | 0
2020-06-18 00:00:00 | 4245221-061820 | 4245221 | Xandy Eredia Golimlim | [NAME] | 5 | 1 | 1 | 1 | 1
2020-06-19 00:00:00 | 4496335-061920 | 4496335 | Gabby Pineda Calderon | [NAME] | 3 | 1 | 0 | 1 | 1
2020-06-19 00:00:00 | 4245221-061920 | 4245221 | Xandy Eredia Golimlim | [NAME] | 5 | 1 | 1 | 1 | 1
2020-06-01 00:00:00 | 5420400-060120 | 5420400 | [NAME] Verances [NAME] | Voice | 0 | 0 | 0 | 1 | 1 | 4763090
2020-06-01 00:00:00 | 5420400-060120 | 5420400 | [NAME] Verances [NAME] | Voice | 5 | 1 | 1 | 0 | 0 | 4763099
2020-06-01 00:00:00 | 5400168-060120 | 5400168 | [NAME] Alberto | Voice | 0 | 0 | 0 | 1 | 0 | 4759599
2020-06-01 00:00:00 | 5400168-060120 | 5400168 | [NAME] Alberto | Voice | 3 | 1 | 0 | 0 | 0 | 4759619
2020-06-02 00:00:00 | 4496335-060220 | 4496335 | Gabby Pineda Calderon | Voice | 2 | 1 | 0 | 0 | 0 | 4768839
2020-06-02 00:00:00 | 4496335-060220 | 4496335 | Gabby Pineda Calderon | Voice | 0 | 0 | 0 | 1 | 0 | 4768886
2020-06-03 00:00:00 | 4496335-060320 | 4496335 | Gabby Pineda Calderon | Voice | 0 | 0 | 0 | 1 | 0 | 4778523
2020-06-03 00:00:00 | 4496335-060320 | 4496335 | Gabby Pineda Calderon | Voice | 1 | 1 | 0 | 0 | 0 | 4778594
2020-06-04 00:00:00 | 5173113-060420 | 5173113 | Abegial Batisan Martin | Voice | 1 | 1 | 0 | 0 | 0 | 4789648
2020-06-04 00:00:00 | 5173113-060420 | 5173113 | Abegial Batisan Martin | Voice | 0 | 0 | 0 | 1 | 0 | 4789666
2020-06-04 00:00:00 | 5420388-060420 | 5420388 | [NAME] | Voice | 5 | 1 | 1 | 0 | 0 | 4796949
2020-06-04 00:00:00 | 5420388-060420 | 5420388 | [NAME] | Voice | 0 | 0 | 0 | 1 | 1 | 4796970
2020-06-05 00:00:00 | 5420391-060520 | 5420391 | [NAME] | Voice | 1 | 1 | 0 | 0 | 0 | 4800889
2020-06-05 00:00:00 | 5420391-060520 | 5420391 | [NAME] | Voice | 0 | 0 | 0 | 1 | 0 | 4802308
2020-06-05 00:00:00 | 5420413-060520 | 5420413 | [NAME] Meneses | Voice | 2 | 1 | 0 | 0 | 0 | 4808138
2020-06-05 00:00:00 | 5420413-060520 | 5420413 | [NAME] Meneses | Voice | 0 | 0 | 0 | 1 | 0 | 4808272
2020-06-05 00:00:00 | 5420391-060520 | 5420391 | [NAME] | Voice | 5 | 1 | 1 | 0 | 0 | 4804133
2020-06-05 00:00:00 | 5420391-060520 | 5420391 | [NAME] | Voice | 0 | 0 | 0 | 1 | 0 | 4807567
2020-06-09 00:00:00 | 5400168-060920 | 5400168 | [NAME] Alberto | Voice | 0 | 0 | 0 | 1 | 0 | 4832923
2020-06-09 00:00:00 | 5400168-060920 | 5400168 | [NAME] Alberto | Voice | 0 | 0 | 0 | 1 | 0 | 4831390
2020-06-09 00:00:00 | 5400168-060920 | 5400168 | [NAME] Alberto | Voice | 4 | 1 | 1 | 0 | 0 | 4831419
2020-06-10 00:00:00 | 5173113-061020 | 5173113 | Abegial Batisan Martin | Voice | 0 | 0 | 0 | 1 | 0 | 4838610
2020-06-10 00:00:00 | 5400168-061020 | 5400168 | [NAME] Alberto | Voice | 1 | 1 | 0 | 0 | 0 | 4842026
2020-06-10 00:00:00 | 5400168-061020 | 5400168 | [NAME] Alberto | Voice | 0 | 0 | 0 | 1 | 0 | 4842064
2020-06-10 00:00:00 | 5420413-061020 | 5420413 | [NAME] Meneses | Voice | 0 | 0 | 0 | 1 | 0 | 4845430
2020-06-10 00:00:00 | 5420413-061020 | 5420413 | [NAME] Meneses | Voice | 3 | 1 | 0 | 0 | 0 | 4845442
2020-06-10 00:00:00 | 5420391-061020 | 5420391 | [NAME] | Voice | 5 | 1 | 1 | 0 | 0 | 4839142
2020-06-10 00:00:00 | 5420391-061020 | 5420391 | [NAME] | Voice | 0 | 0 | 0 | 1 | 1 | 4839166
2020-06-11 00:00:00 | 4496335-061120 | 4496335 | Gabby Pineda Calderon | Voice | 5 | 1 | 1 | 0 | 0 | 4851893
2020-06-11 00:00:00 | 4496335-061120 | 4496335 | Gabby Pineda Calderon | Voice | 0 | 0 | 0 | 1 | 1 | 4851961
2020-06-11 00:00:00 | 4496335-061120 | 4496335 | Gabby Pineda Calderon | Voice | 3 | 1 | 0 | 0 | 0 | 4850168
2020-06-11 00:00:00 | 4496335-061120 | 4496335 | Gabby Pineda Calderon | Voice | 0 | 0 | 0 | 1 | 1 | 4850302
2020-06-12 00:00:00 | 4496335-061220 | 4496335 | Gabby Pineda Calderon | Voice | 0 | 0 | 0 | 1 | 0 | 4862013
2020-06-12 00:00:00 | 4496335-061220 | 4496335 | Gabby Pineda Calderon | Voice | 5 | 1 | 1 | 0 | 0 | 4862063
2020-06-12 00:00:00 | 5420391-061220 | 5420391 | [NAME] | Voice | 5 | 1 | 1 | 0 | 0 | 4868404
2020-06-12 00:00:00 | 5420391-061220 | 5420391 | [NAME] | Voice | 0 | 0 | 0 | 1 | 0 | 4868428
2020-06-12 00:00:00 | 5420388-061220 | 5420388 | [NAME] | Voice | 5 | 1 | 1 | 0 | 0 | 4861864
2020-06-12 00:00:00 | 5420413-061220 | 5420413 | [NAME] Meneses | Voice | 0 | 0 | 0 | 1 | 0 | 4867660
2020-06-12 00:00:00 | 5420413-061220 | 5420413 | [NAME] Meneses | Voice | 3 | 1 | 0 | 0 | 0 | 4867696
2020-06-12 00:00:00 | 5400168-061220 | 5400168 | [NAME] Alberto | Voice | 1 | 1 | 0 | 0 | 0 | 4867707
2020-06-15 00:00:00 | 5420388-061520 | 5420388 | [NAME] | Voice | 5 | 1 | 1 | 0 | 0 | 4879521
2020-06-15 00:00:00 | 5420388-061520 | 5420388 | [NAME] | Voice | 0 | 0 | 0 | 1 | 1 | 4879529
2020-06-15 00:00:00 | 5420391-061520 | 5420391 | [NAME] | Voice | 0 | 0 | 0 | 1 | 0 | 4885885
2020-06-15 00:00:00 | 5420391-061520 | 5420391 | [NAME] | Voice | 4 | 1 | 1 | 0 | 0 | 4885891
2020-06-15 00:00:00 | 5420391-061520 | 5420391 | [NAME] | Voice | 0 | 0 | 0 | 1 | 1 | 4883861
2020-06-15 00:00:00 | 5420391-061520 | 5420391 | [NAME] | Voice | 5 | 1 | 1 | 0 | 0 | 4883899
2020-06-16 00:00:00 | 5400168-061620 | 5400168 | [NAME] Alberto | Voice | 5 | 1 | 1 | 0 | 0 | 4892820
2020-06-16 00:00:00 | 5400168-061620 | 5400168 | [NAME] Alberto | Voice | 0 | 0 | 0 | 1 | 1 | 4892835
2020-06-16 00:00:00 | 5400168-061620 | 5400168 | [NAME] Alberto | Voice | 3 | 1 | 0 | 0 | 0 | 4891982
2020-06-16 00:00:00 | 5400168-061620 | 5400168 | [NAME] Alberto | Voice | 0 | 0 | 0 | 1 | 0 | 4891983
2020-06-17 00:00:00 | 4496335-061720 | 4496335 | Gabby Pineda Calderon | Voice | 1 | 1 | 0 | 0 | 0 | 4906149
2020-06-17 00:00:00 | 4496335-061720 | 4496335 | Gabby Pineda Calderon | Voice | 0 | 0 | 0 | 1 | 0 | 4906277
2020-06-17 00:00:00 | 5420400-061720 | 5420400 | [NAME] Verances [NAME] | Voice | 0 | 0 | 0 | 1 | 1 | 4909118
2020-06-17 00:00:00 | 5420400-061720 | 5420400 | [NAME] Verances [NAME] | Voice | 5 | 1 | 1 | 0 | 0 | 4909132
2020-06-17 00:00:00 | 5420388-061720 | 5420388 | [NAME] | Voice | 0 | 0 | 0 | 1 | 1 | 4907922
2020-06-17 00:00:00 | 5400168-061720 | 5400168 | [NAME] Alberto | Voice | 3 | 1 | 0 | 0 | 0 | 4905197
2020-06-17 00:00:00 | 5400168-061720 | 5400168 | [NAME] Alberto | Voice | 0 | 0 | 0 | 1 | 0 | 4905380
2020-06-17 00:00:00 | 5400168-061720 | 5400168 | [NAME] Alberto | Voice | 1 | 1 | 0 | 0 | 0 | 4905433
2020-06-17 00:00:00 | 5400168-061720 | 5400168 | [NAME] Alberto | Voice | 0 | 0 | 0 | 1 | 0 | 4905449
2020-06-18 00:00:00 | 4496335-061820 | 4496335 | Gabby Pineda Calderon | Voice | 0 | 0 | 0 | 1 | 1 | 4918370
2020-06-18 00:00:00 | 4496335-061820 | 4496335 | Gabby Pineda Calderon | Voice | 3 | 1 | 0 | 0 | 0 | 4918408
2020-06-19 00:00:00 | 5173113-061920 | 5173113 | Abegial Batisan Martin | Voice | 5 | 1 | 1 | 0 | 0 | 4928779
2020-06-19 00:00:00 | 5173113-061920 | 5173113 | Abegial Batisan Martin | Voice | 0 | 0 | 0 | 1 | 1 | 4928783
2020-06-19 00:00:00 | 5420388-061920 | 5420388 | [NAME] | Voice | 5 | 1 | 1 | 0 | 0 | 4927729
2020-06-19 00:00:00 | 5420388-061920 | 5420388 | [NAME] | Voice | 0 | 0 | 0 | 1 | 1 | 4927821
2020-06-22 00:00:00 | 5400168-062220 | 5400168 | [NAME] Alberto | Voice | 5 | 1 | 1 | 0 | 0 | 4939750
2020-06-22 00:00:00 | 5400168-062220 | 5400168 | [NAME] Alberto | Voice | 0 | 0 | 0 | 1 | 1 | 4939764
2020-06-22 00:00:00 | 5420391-062220 | 5420391 | [NAME] | Voice | 0 | 0 | 0 | 1 | 1 | 4946492
2020-06-22 00:00:00 | 5420391-062220 | 5420391 | [NAME] | Voice | 5 | 1 | 1 | 0 | 0 | 4946527
2020-06-22 00:00:00 | 5420391-062220 | 5420391 | [NAME] | Voice | 0 | 0 | 0 | 1 | 0 | 4943612
2020-06-22 00:00:00 | 5400168-062220 | 5400168 | [NAME] Alberto | Voice | 1 | 1 | 0 | 0 | 0 | 4946357
2020-06-22 00:00:00 | 5400168-062220 | 5400168 | [NAME] Alberto | Voice | 0 | 0 | 0 | 1 | 0 | 4946377
2020-06-22 00:00:00 | 5420391-062220 | 5420391 | [NAME] | Voice | 1 | 1 | 0 | 0 | 0 | 4940904
2020-06-22 00:00:00 | 5420391-062220 | 5420391 | [NAME] | Voice | 0 | 0 | 0 | 1 | 0 | 4940928
2020-06-22 00:00:00 | 4245221-062220 | 4245221 | Xandy Eredia Golimlim | Voice | 5 | 1 | 1 | 0 | 0 | 4944750
2020-06-22 00:00:00 | 4245221-062220 | 4245221 | Xandy Eredia Golimlim | Voice | 0 | 0 | 0 | 1 | 1 | 4944788
2020-06-22 00:00:00 | 5400168-062220 | 5400168 | [NAME] Alberto | Voice | 0 | 0 | 0 | 1 | 0 | 4944810
2020-06-22 00:00:00 | 5400168-062220 | 5400168 | [NAME] Alberto | Voice | 2 | 1 | 0 | 0 | 0 | 4944822
2020-06-23 00:00:00 | 5400168-062320 | 5400168 | [NAME] Alberto | Voice | 0 | 0 | 0 | 1 | 0 | 4958303
2020-06-23 00:00:00 | 5400168-062320 | 5400168 | [NAME] Alberto | Voice | 1 | 1 | 0 | 0 | 0 | 4958318
2020-06-23 00:00:00 | 5420388-062320 | 5420388 | [NAME] | Voice | 1 | 1 | 0 | 0 | 0 | 4954704
2020-06-23 00:00:00 | 5420388-062320 | 5420388 | [NAME] | Voice | 0 | 0 | 0 | 1 | 1 | 4954709
2020-06-23 00:00:00 | 5420388-062320 | 5420388 | [NAME] | Voice | 0 | 0 | 0 | 1 | 1 | 4954365
2020-06-23 00:00:00 | 5420388-062320 | 5420388 | [NAME] | Voice | 5 | 1 | 1 | 0 | 0 | 4954389
2020-06-23 00:00:00 | 5420391-062320 | 5420391 | [NAME] | Voice | 4 | 1 | 1 | 0 | 0 | 4958272
2020-06-23 00:00:00 | 5420391-062320 | 5420391 | [NAME] | Voice | 0 | 0 | 0 | 1 | 0 | 4958297