CSV importeren

Alleen letters/cijfers/_ (prefix csv_ of fac_)

CSV gegevens

Match met jortklanten, bereken kolommen, bewerk trx_price, SID groeperen en exporteer “zonder match”.

Tabel csv_492025_TEST — totaal 534 rijen — zonder match: 12
id
Klantnr
Naam
SID
DebitCount
DebitAmount
CreditCountNW
CreditAmountNW
check
trx_price
1 10110835 Pay Sofort B.V. 8427690 0 0.00 0 0.00 1e3540b4-86a2-494e-9a13-0990a7dbcbd0 0.07
2 10110835 Pay Sofort B.V. 8526915 0 0.00 0 0.00 1e3540b4-86a2-494e-9a13-0990a7dbcbd0 0.07
3 10110835 Pay Sofort B.V. 8526923 0 0.00 0 0.00 1e3540b4-86a2-494e-9a13-0990a7dbcbd0 0.07
4 10122639 Alfa Supermarkt B.V. 5059631 0 0.00 0 0.00 9e2a5034-9693-4c04-8b18-fd2ae4c55a81 0.07
5 10122639 Alfa Supermarkt B.V. 5059658 0 0.00 0 0.00 9e2a5034-9693-4c04-8b18-fd2ae4c55a81 0.07
6 10122639 Alfa Supermarkt B.V. 5065909 0 0.00 0 0.00 9e2a5034-9693-4c04-8b18-fd2ae4c55a81 0.07
7 10122655 SR Supermarkt 5059690 2877 14679.33 24 129.75 c0238198-165c-4fec-938d-65f27cf959c0 0.07
8 10122658 Princessa Polski Sklep 5059410 0 0.00 0 0.00 edf45deb-2b04-48e1-a38f-81df1bc770f3 0.07
9 10122675 Spaans Tapas Restaurant El Olivo V.O.F. 5059429 224 28416.05 8 1229.90 c22ac6f7-51be-40ca-9c1f-9aa3fe0c5efa 0.07
10 10122715 Vis&zo Beverwijk 5059445 0 0.00 0 0.00 0.07
11 10122785 GEWOON JIJ Joos Fashion 5059585 117 5371.16 3 227.70 e2dce86e-c4a4-4509-b4b5-496376b0c6f9 0.07
12 10122927 Donerenkebabstudio 5059941 0 0.00 0 0.00 2ac66e4a-b89e-403e-978c-58b3c8f9f963 0.07
13 10123006 V.O.F. GSM Hillegom 5060044 414 15101.09 1 15.00 e838f9a3-ae0d-4e88-9dd3-925425e83417 0.07
14 10123422 FITBYSEZ 5060427 206 4702.22 5 132.80 37755c68-1dad-412e-aeb5-9f12ad8b153f 0.07
15 10123430 Sky Abeltje Sigaar v.o.f. 5060435 2402 40964.46 51 1168.73 8c617fd7-1a4f-40be-b29d-61e42a90a678 0.07
16 10123564 Almina Rotterdam West 5060664 0 0.00 0 0.00 e687fa99-2d27-48b4-8ebe-ecb6bdfbc3f2 0.07
17 10124405 Landorette 5062233 321 10490.20 64 1718.50 f7f57f20-ac24-45f9-9847-69ba91ddc643 0.07
18 10124454 Supermarkt Trakiya 5062179 1014 6538.93 4 34.20 70a8f542-930d-445f-ae09-232e75a8128b 0.07
19 10124681 Darin barbershop 5062500 678 17242.30 3 82.50 1cb928b5-522f-4d1f-b4ac-25a93ac887af 0.07
20 10124753 Sali "S" 5062578 1 13.00 0 0.00 b4e02f40-c3d3-4766-9b46-898aee2e3d5a 0.07
21 10124753 Sali "S" 5062586 1306 12380.35 20 144.20 b4e02f40-c3d3-4766-9b46-898aee2e3d5a 0.07
22 10124949 Almina Kardesler Bakkerij 5062780 0 0.00 0 0.00 077d1a3c-a6d1-440c-9789-1d0aed74fcfc 0.07
23 10124959 Pasikonik Schiedam B.V. 5063000 0 0.00 0 0.00 b59bdb05-7bf0-4be2-b304-a8ec7902ffe2 0.07
24 10124959 Pasikonik Schiedam B.V. 5069874 5111 53315.26 124 1647.90 b59bdb05-7bf0-4be2-b304-a8ec7902ffe2 0.07
25 10124979 Elitesy B.V. 5062993 0 0.00 0 0.00 7ab1de9a-b24c-440d-8a83-dfbf1d1c8989 0.07
26 10125139 La Modeloboutique 5063175 58 8451.80 3 664.98 786605e7-4587-4f72-9d69-95e68086c619 0.07
27 10125139 La Modeloboutique 5063183 58 10514.84 5 1535.00 786605e7-4587-4f72-9d69-95e68086c619 0.07
28 10125387 AMALIA.LD 5063809 0 0.00 0 0.00 cc2063ae-4434-468b-8945-b23011037e4f 0.07
29 10125471 Nika supermarkt 5063914 3814 37842.27 127 1511.03 b63fb69c-9bc9-414b-b192-8c7b7d82797f 0.07
30 10125522 Royal Hand Carwash 5064031 204 9178.25 6 345.00 b1d5bc0d-f000-4416-93a7-6e94a8afb94b 0.07
31 10125544 MCA B.V. 5064090 0 0.00 0 0.00 bb29707e-86df-484d-bc09-e1a0cba67f8b 0.07
32 10125572 Kirisha Wedding and Cleaning 5064120 0 0.00 0 0.00 6042ba3f-3586-452a-b815-e3de77d033aa 0.07
33 10125575 Schoenmakerij The Cobbler 5064163 0 0.00 0 0.00 fde8e88b-4bbf-4f46-b0cd-2351da390870 0.07
34 10125580 RKR Catering V.O.F. 5064155 443 8158.90 2 21.00 3ea368bb-4fb8-4427-8d7c-9bdc6fbda77d 0.07
35 10125832 Polo Supermarkt Slinge B.V. 5064457 9528 128192.98 187 2574.08 ca29ef82-4d3a-4864-aa73-683240454beb 0.07
36 10125832 Polo Supermarkt Slinge B.V. 5621585 593 8264.38 56 1078.25 ca29ef82-4d3a-4864-aa73-683240454beb 0.07
37 10126435 G. Penders 5066336 0 0.00 0 0.00 090c3698-84bf-4262-964d-8d7ba06d4990 0.07
38 10126482 Del Plata 5065925 2011 34887.12 238 3782.20 251a3dce-f595-4b69-8a88-f2bc1308afe8 0.07
39 10126701 'T Hofje 5066182 0 0.00 0 0.00 8a1c1b42-672c-4fbd-9046-dbd549db8d93 0.07
40 10126702 Mrs. Sam Supermarket B.V. 5066174 7557 125681.92 409 6922.77 ea2a3fbb-dbce-4b5a-9d68-47e5df9355d4 0.07
41 10126702 Mrs. Sam Supermarket B.V. 5649587 344 6133.17 23 547.79 ea2a3fbb-dbce-4b5a-9d68-47e5df9355d4 0.07
42 10126703 Start Premium 5066166 1408 14294.96 28 297.47 42e68725-ec66-47cd-ae0c-718c930dad93 0.07
43 10126704 Pizzeria Mama Mia Blerick 5066190 121 2227.35 4 75.50 ebd2e449-8de1-4671-b01a-c353e19d4be2 0.07
44 10126705 GrabnGo 5066204 4888 38195.20 0 0.00 4ffba31f-c0f8-4a41-8b19-e4f7708a5b53 0.07
45 10126705 GrabnGo 5402670 0 0.00 0 0.00 4ffba31f-c0f8-4a41-8b19-e4f7708a5b53 0.07
46 10126706 Sen Kardesler Bakkerij 5066212 0 0.00 0 0.00 069ec4f2-31cd-48ad-ac90-3f3d48ff50e0 0.07
47 10126988 Eethuis Helal 5066859 1906 22425.10 28 351.65 9664ce64-0a1e-4f00-87e0-b67caabe8986 0.07
48 10127007 Bakery Yummy 5066905 495 2903.86 22 154.09 a578022c-16e1-482b-97b5-d9f77d554f80 0.07
49 10127014 Sum Hair & Beautysalon 5066948 43 1296.00 0 0.00 dc481bce-febf-4279-8458-bd03d13880c8 0.07
50 10127035 Euro Company 5066964 0 0.00 0 0.00 01ccbbdc-dbd5-4563-a810-e0f6b2a0a043 0.07
Pagina 1 van 11 — getoond: 50 / 534