Spreadsheet: 746340d1630650068-comparing-two-tabs-for-differences-in-quantity-pq-qty-differences
Sheet: Merge1

Status | Date | Customer ID | Product Name | Transaction # | Product ID (Truncated) | Product ID | Product Description | Quantity | Aug.Product ID | Aug.Quantity | Difference
Active | 2021-07-05 00:00:00 | 8997182 | [NAME] | 69690275 | 9245 | 9245_HDH | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 34 | 9245_HDH | 34 | True
Active | 2021-07-01 00:00:00 | 7999485 | [NAME] | 69698701 | 8758 | 8758_LVB | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 91 | 8758_LVB | 91 | True
Active | 2021-07-13 00:00:00 | 5814075 | [NAME] | 69693212 | 7113 | 7113_MNY | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 35 | 7113_MNY | 35 | True
Active | 2021-07-30 00:00:00 | 8931216 | [NAME] | 69693562 | 6515 | 6515_HZY | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 100 | 6515_HZY | 100 | True
Active | 2021-07-29 00:00:00 | 4049237 | Butterfinger | 69697772 | 6291 | 6291_LVB | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 49 | 6291_LVB | 49 | True
Active | 2021-07-14 00:00:00 | 6697313 | Cadbury eggs | 69699792 | 1556 | 1556_LVB | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 41 | 1556_LVB | 41 | True
Active | 2021-07-03 00:00:00 | 7609222 | Candy cigarettes | 69694921 | 8047 | 8047_TEW | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 14 | 8047_TEW | 14 | True
Active | 2021-07-26 00:00:00 | 1492880 | Candy corn | 69691644 | 4162 | 4162_CZA | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 97 | 4162_CZA | 97 | True
Active | 2021-07-10 00:00:00 | 9790596 | Candy corn | 69699586 | 4163 | 4163_CZA | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 84 |  |  | False
Active | 2021-07-15 00:00:00 | 3041375 | Circus peanuts | 69691057 | 7863 | 7863_HDH | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 78 | 7863_HDH | 84 | False
Active | 2021-07-17 00:00:00 | 6888671 | Cotton candy | 69692161 | 2748 | 2748_HZY | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 36 | 2748_HZY | 78 | False
Active | 2021-07-12 00:00:00 | 9365552 | [NAME] | 69692601 | 7586 | 7586_HZY | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 92 | 7586_HZY | 36 | False
Active | 2021-07-25 00:00:00 | 6135169 | [NAME] | 69698450 | 7097 | 7097_EGX | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 6 | 7097_EGX | 92 | False
Active | 2021-07-08 00:00:00 | 4794632 | Hershey's Kisses | 69697031 | 7308 | 7308_YPC | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 6 | 7308_YPC | 6 | True
Inactive | 2021-07-20 00:00:00 | 9029213 | [NAME] | 69698000 | 7098 | 7098_EGX | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 6 |  |  | False
Active | 2021-07-04 00:00:00 | 2086703 | Jawbreakers | 69697520 | 8673 | 8673_OEU | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 47 | 8673_OEU | 47 | True
Active | 2021-07-24 00:00:00 | 7799226 | Jelly Belly | 69691373 | 2606 | 2606_EGX | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 12 | 2606_EGX | 12 | True
Active | 2021-07-02 00:00:00 | 5556931 | Jolly Ranchers | 69690462 | 5778 | 5778_YPC | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 23 | 5778_YPC | 23 | True
Active | 2021-07-22 00:00:00 | 4049237 | Junior Mints | 69690957 | 9123 | 9123_YPC | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 55 | 9123_YPC | 55 | True
Inactive | 2021-07-18 00:00:00 | 9620464 | Kit-Kat | 69691016 | 7679 | 7679_HDH | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 80 | 7679_HDH | 80 | True
Active | 2021-07-16 00:00:00 | 1581685 | M&Ms | 69698626 | 8720 | 8720_TEW | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 1 | 8720_TEW | 1 | True
Inactive | 2021-07-07 00:00:00 | 1298586 | Milk Duds | 69699633 | 7468 | 7468_YPC | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 74 | 7468_YPC | 74 | True
Active | 2021-07-27 00:00:00 | 3406386 | Milky Way | 69698988 | 4179 | 4179_HDH | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 28 | 4179_HDH | 28 | True
Active | 2021-07-21 00:00:00 | 6749712 | Mr. [NAME] | 69698689 | 9603 | 9603_OEU | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 10 | 9603_OEU | 10 | True
Active | 2021-07-26 00:00:00 | 6722817 | Necco wafers | 69693596 | 7100 | 7100_OEU | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 29 | 7100_OEU | 60 | False
Active | 2021-07-02 00:00:00 | 9923606 | Nerds | 69697413 | 6740 | 6740_CZA | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 66 | 6740_CZA | 29 | False
Active | 2021-07-19 00:00:00 | 2302777 | Mr. [NAME] | 69691203 | 9604 | 9604_OEU | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 60 |  |  | False
Inactive | 2021-07-09 00:00:00 | 6697313 | [NAME] | 69699666 | 7591 | 7591_LVB | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 37 | 7591_LVB | 66 | False
Active | 2021-07-08 00:00:00 | 2068317 | Payday | 69692551 | 9757 | 9757_MNY | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 69 | 9757_MNY | 56 | False
Active | 2021-07-21 00:00:00 | 6494855 | Peeps | 69691813 | 1594 | 1594_LVB | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 17 | 1594_LVB | 37 | False
Active | 2021-07-11 00:00:00 | 6538768 | Nerds | 69699500 | 6741 | 6741_CZA | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 56 |  |  | False
Active | 2021-07-18 00:00:00 | 6494855 | Pez | 69695716 | 2139 | 2139_MNY | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 26 | 2139_MNY | 69 | False
Active | 2021-07-04 00:00:00 | 4798887 | [NAME] | 69695271 | 3444 | 3444_TEW | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 25 | 3444_TEW | 17 | False
Active | 2021-07-01 00:00:00 | 8803534 | Pocky | 69690820 | 8001 | 8001_EGX | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 2 | 8001_EGX | 26 | False
Active | 2021-07-22 00:00:00 | 6570671 | Pop Rocks | 69698428 | 5940 | 5940_EGX | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 43 | 5940_EGX | 25 | False
Active | 2021-07-03 00:00:00 | 3048022 | Red Vines | 69697778 | 9892 | 9892_HDH | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 95 | 9892_HDH | 2 | False
Active | 2021-07-13 00:00:00 | 8563122 | Reese's Peanut Butter Cups | 69694518 | 2127 | 2127_CZA | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 99 | 2127_CZA | 53 | False
Inactive | 2021-07-06 00:00:00 | 4356942 | Reese's pieces | 69699786 | 8281 | 8281_CZA | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 53 | 8281_CZA | 43 | False
Active | 2021-07-24 00:00:00 | 9159913 | Pocky | 69691517 | 8002 | 8002_EGX | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 53 |  |  | False
Active | 2021-07-07 00:00:00 | 6577326 | Salt water taffy | 69692815 | 8139 | 8139_MNY | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 43 | 8139_MNY | 5 | False
Active | 2021-07-15 00:00:00 | 8973434 | Skittles | 69690271 | 7737 | 7737_OEU | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 95 | 7737_OEU | 95 | True
Inactive | 2021-07-29 00:00:00 | 4314183 | Pop Rocks | 69698125 | 5941 | 5941_EGX | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 5 |  |  | False
Active | 2021-07-05 00:00:00 | 6924535 | Snickers | 69692158 | 4819 | 4819_TEW | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 81 | 4819_TEW | 99 | False
Active | 2021-07-02 00:00:00 | 7999485 | Sour Patch Kids | 69696919 | 5694 | 5694_LVB | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 81 | 5694_LVB | 81 | True
Active | 2021-07-14 00:00:00 | 5556931 | Starburst | 69691072 | 5976 | 5976_HDH | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 65 | 5976_HDH | 65 | True
Inactive | 2021-07-12 00:00:00 | 6494855 | Reese's Peanut Butter Cups | 69692475 | 2128 | 2128_CZA | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 81 |  |  | False
Active | 2021-07-11 00:00:00 | 1827650 | Sugar Daddy | 69692335 | 2660 | 2660_CZA | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 46 | 2660_CZA | 46 | True
Active | 2021-07-17 00:00:00 | 5046010 | Swedish Fish | 69699687 | 9313 | 9313_YPC | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 75 | 9313_YPC | 75 | True
Active | 2021-07-28 00:00:00 | 3158905 | Three Musketeers | 69696696 | 1085 | 1085_OEU | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 58 | 1085_OEU | 58 | True
Inactive | 2021-07-30 00:00:00 | 8136218 | Salt water taffy | 69692612 | 8140 | 8140_MNY | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 5 |  |  | False
Active | 2021-07-13 00:00:00 | 6961642 | Toblerone | 69698858 | 8421 | 8421_HZY | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 87 | 8421_HZY | 87 | True
Active | 2021-07-04 00:00:00 | 6226808 | Tootsie Roll Pops | 69693356 | 2516 | 2516_OEU | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 62 | 2516_OEU | 62 | True
Active | 2021-07-26 00:00:00 | 9914454 | Skittles | 69693624 | 7738 | 7738_OEU | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 99 |  |  | False
Active | 2021-07-22 00:00:00 | 4798887 | [NAME] | 69697963 | 3262 | 3262_HZY | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 38 | 3262_HZY | 33 | False
Active | 2021-07-05 00:00:00 | 5814075 | [NAME] | 69697582 | 1969 | 1969_MNY | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 39 | 1969_MNY | 38 | False
Inactive | 2021-07-19 00:00:00 | 5814075 | Snickers | 69692908 | 4820 | 4820_TEW | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 0 |  |  | False
Active | 2021-07-07 00:00:00 | 6697313 | Twizzlers | 69693375 | 2165 | 2165_EGX | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 51 | 2165_EGX | 39 | False
Active | 2021-07-12 00:00:00 | 5249440 | Wax lips | 69693973 | 5280 | 5280_TEW | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 22 | 5280_TEW | 51 | False
Inactive | 2021-07-10 00:00:00 | 6494855 | Sour Patch Kids | 69692676 | 5695 | 5695_LVB | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 15 |  |  | False
Active | 2021-07-26 00:00:00 | 6337383 | Werther's Original | 69696115 | 3460 | 3460_OEU | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 9 | 3460_OEU | 9 | True
Active | 2021-07-15 00:00:00 | 1924040 | York Peppermint Patties | 69693217 | 3416 | 3416_CZA | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 22 | 3416_CZA | 22 | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
Inactive | 2021-07-18 00:00:00 | 3041375 | Tootsie Roll Pops | 69690974 | 2517 | 2517_OEU | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 33 |  |  | False
Inactive | 2021-07-21 00:00:00 | 7799226 | Twizzlers | 69695259 | 2166 | 2166_EGX | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 9 |  |  | False
Inactive | 2021-07-11 00:00:00 | 6697313 | Wax lips | 69699955 | 5281 | 5281_TEW | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 51 |  |  | False
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  |  |  |  | True