Created
February 1, 2023 22:12
-
-
Save fomightez/2be7cecb3807033d036b8af7d9dcbcba to your computer and use it in GitHub Desktop.
adapted top of https://github.com/cwarden/kettle/blob/master/samples/transformations/files/sales_data.csv to match columns in https://stackoverflow.com/q/75301066/8508004
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ORDERNUMBER | Quantity Ordered | Price Each | ORDERLINENUMBER | SALES | ORDERDATE | STATUS | QTR_ID | Month | YEAR_ID | Product | MSRP | PRODUCTCODE | CUSTOMERNAME | PHONE | ADDRESSLINE1 | ADDRESSLINE2 | City | STATE | POSTALCODE | COUNTRY | TERRITORY | CONTACTLASTNAME | CONTACTFIRSTNAME | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10107 | 30 | 95.7 | 2 | 2871 | 2/24/2003 0:00 | Shipped | 1 | 2 | 2003 | Motorcycles | 95 | S10_1678 | Land of Toys Inc. | 2125557818 | 897 Long Airport Avenue | NYC | NY | 10022 | United States | NA | Yu | Kwai | ||
| 10121 | 34 | 81.35 | 5 | 2765.9 | 5/7/2003 0:00 | Shipped | 2 | 5 | 2003 | Motorcycles | 95 | S10_1678 | Reims Collectables | 26.47.1555 | 59 rue de l'Abbaye | Reims | 51100 | France | EMEA | Henriot | Paul | |||
| 10134 | 41 | 94.74 | 2 | 3884.34 | 7/1/2003 0:00 | Shipped | 3 | 7 | 2003 | Motorcycles | 95 | S10_1678 | Lyon Souveniers | +33 1 46 62 7555 | 27 rue du Colonel Pierre Avia | Paris | 75508 | France | EMEA | Da Cunha | Daniel | |||
| 10145 | 45 | 83.26 | 6 | 3746.7 | 8/25/2003 0:00 | Shipped | 3 | 8 | 2003 | Motorcycles | 95 | S10_1678 | Toys4GrownUps.com | 6265557265 | 78934 Hillside Dr. | Pasadena | CA | 90003 | USA | NA | Young | Julie | ||
| 10159 | 49 | 100 | 14 | 5205.27 | 10/10/2003 0:00 | Shipped | 4 | 10 | 2003 | Motorcycles | 95 | S10_1678 | Corporate Gift Ideas Co. | 6505551386 | 7734 Strong St. | San Francisco | CA | United States | NA | Brown | Julie | |||
| 10168 | 36 | 96.66 | 1 | 3479.76 | 10/28/2003 0:00 | Shipped | 4 | 10 | 2003 | Motorcycles | 95 | S10_1678 | Technics Stores Inc. | 6505556809 | 9408 Furth Circle | Burlingame | CA | 94217 | USA | NA | Hirano | Juri | ||
| 10180 | 29 | 86.13 | 9 | 2497.77 | 11/11/2003 0:00 | Shipped | 4 | 11 | 2003 | Motorcycles | 95 | S10_1678 | Daedalus Designs Imports | 20.16.1555 | 184, chauss�e de Tournai | Lille | 59000 | France | EMEA | Ranc� | Martine | |||
| 10188 | 48 | 100 | 1 | 5512.32 | 11/18/2003 0:00 | Shipped | 4 | 11 | 2003 | Motorcycles | 95 | S10_1678 | Herkku Gifts | +47 2267 3215 | Drammen 121, PR 744 Sentrum | Bergen | N 5804 | Norway | EMEA | Oeztan | Veysel | |||
| 10201 | 22 | 98.57 | 2 | 2168.54 | 12/1/2003 0:00 | Shipped | 4 | 12 | 2003 | Motorcycles | 95 | S10_1678 | Mini Wheels Co. | 6505555787 | 5557 North Pendale Street | San Francisco | CA | United States | NA | Murphy | Julie | |||
| 10211 | 41 | 100 | 14 | 4708.44 | 1/15/2004 0:00 | Shipped | 1 | 1 | 2004 | Motorcycles | 95 | S10_1678 | Auto Canal+ Petit | (1) 47.55.6555 | 25, rue Lauriston | Paris | 75016 | France | EMEA | Perrier | Dominique | |||
| 10223 | 37 | 100 | 1 | 3965.66 | 2/20/2004 0:00 | Shipped | 1 | 2 | 2004 | Motorcycles | 95 | S10_1678 | Australian Collectors, Co. | 03 9520 4555 | 636 St Kilda Road | Level 3 | Melbourne | Victoria | 3004 | Australia | APAC | Ferguson | Peter | |
| 10237 | 23 | 100 | 7 | 2333.12 | 4/5/2004 0:00 | Shipped | 2 | 4 | 2004 | Motorcycles | 95 | S10_1678 | Vitachrome Inc. | 2125551500 | 2678 Kingston Rd. | Suite 101 | NYC | NY | 10022 | USA | NA | Frick | Michael | |
| 10251 | 28 | 100 | 2 | 3188.64 | 5/18/2004 0:00 | Shipped | 2 | 5 | 2004 | Motorcycles | 95 | S10_1678 | Tekni Collectables Inc. | 2015559350 | 7476 Moss Rd. | Newark | NJ | 94019 | USA | NA | Brown | William | ||
| 10263 | 34 | 100 | 2 | 3676.76 | 6/28/2004 0:00 | Shipped | 2 | 6 | 2004 | Motorcycles | 95 | S10_1678 | Gift Depot Inc. | 2035552570 | 25593 South Bay Ln. | Bridgewater | CT | 97562 | United States | NA | King | Julie | ||
| 10275 | 45 | 92.83 | 1 | 4177.35 | 7/23/2004 0:00 | Shipped | 3 | 7 | 2004 | Motorcycles | 95 | S10_1678 | La Rochelle Gifts | 40.67.8555 | 67, rue des Cinquante Otages | Nantes | 44000 | France | EMEA | Labrune | Janine | |||
| 10285 | 36 | 100 | 6 | 4099.68 | 8/27/2004 0:00 | Shipped | 3 | 8 | 2004 | Motorcycles | 95 | S10_1678 | Marta's Replicas Co. | 6175558555 | 39323 Spinnaker Dr. | Cambridge | MA | 51247 | USA | NA | Hernandez | Marta | ||
| 10299 | 23 | 100 | 9 | 2597.39 | 9/30/2004 0:00 | Shipped | 3 | 9 | 2004 | Motorcycles | 95 | S10_1678 | Toys of Finland, Co. | 90-224 8555 | Keskuskatu 45 | Helsinki | 21240 | Finland | EMEA | Karttunen | Matti | |||
| 10309 | 41 | 100 | 5 | 4394.38 | 10/15/2004 0:00 | Shipped | 4 | 10 | 2004 | Motorcycles | 95 | S10_1678 | Baane Mini Imports | 07-98 9555 | Erling Skakkes gate 78 | Stavern | 4110 | Norway | EMEA | Bergulfsen | Jonas | |||
| 10318 | 46 | 94.74 | 1 | 4358.04 | 11/2/2004 0:00 | Shipped | 4 | 11 | 2004 | Motorcycles | 95 | S10_1678 | Diecast Classics Inc. | 2155551555 | 7586 Pompton St. | Allentown | PA | 70267 | USA | NA | Yu | Kyung | ||
| 10329 | 42 | 100 | 1 | 4396.14 | 11/15/2004 0:00 | Shipped | 4 | 11 | 2004 | Motorcycles | 95 | S10_1678 | Land of Toys Inc. | 2125557818 | 897 Long Airport Avenue | NYC | NY | 10022 | United States | NA | Yu | Kwai | ||
| 10341 | 41 | 100 | 9 | 7737.93 | 11/24/2004 0:00 | Shipped | 4 | 11 | 2004 | Motorcycles | 95 | S10_1678 | Salzburg Collectables | 6562-9555 | Geislweg 14 | Salzburg | 5020 | Austria | EMEA | Pipps | Georg | |||
| 10361 | 20 | 72.55 | 13 | 1451 | 12/17/2004 0:00 | Shipped | 4 | 12 | 2004 | Motorcycles | 95 | S10_1678 | Souveniers And Things Co. | +61 2 9495 8555 | Monitor Money Building, 815 Pacific Hwy | Level 6 | Chatswood | NSW | 2067 | Australia | APAC | Huxley | Adrian | |
| 10375 | 21 | 34.91 | 12 | 733.11 | 2/3/2005 0:00 | Shipped | 1 | 2 | 2005 | Motorcycles | 95 | S10_1678 | La Rochelle Gifts | 40.67.8555 | 67, rue des Cinquante Otages | Nantes | 44000 | France | EMEA | Labrune | Janine | |||
| 10388 | 42 | 76.36 | 4 | 3207.12 | 3/3/2005 0:00 | Shipped | 1 | 3 | 2005 | Motorcycles | 95 | S10_1678 | FunGiftIdeas.com | 5085552555 | 1785 First Street | New Bedford | MA | 50553 | USA | NA | Benitez | Violeta | ||
| 10403 | 24 | 100 | 7 | 2434.56 | 4/8/2005 0:00 | Shipped | 2 | 4 | 2005 | Motorcycles | 95 | S10_1678 | UK Collectables, Ltd. | (171) 555-2282 | Berkeley Gardens 12 Brewery | Liverpool | WX1 6LT | UK | EMEA | Devon | Elizabeth | |||
| 10417 | 66 | 100 | 2 | 7516.08 | 5/13/2005 0:00 | Disputed | 2 | 5 | 2005 | Motorcycles | 95 | S10_1678 | Euro+ Shopping Channel | (91) 555 94 44 | C/ Moralzarzal, 86 | Madrid | 28034 | Spain | EMEA | Freyre | Diego |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment