Project translated automatically. Log in or register, to view the original There are two tables. Customers and Customer Addresses These two tables are linked with the column "KOD" One client may have one or more addresses and may not have any addresses at all.you need to fill the fields in the client table from the address table ADDR_1_STREETADDR_1_HOUSEADDR_1_APPARTMADDR_1_COMMENTADDR_2_CITYADDR_2_STREETADDR_2_HOUSEADDR_2_APPARTMADDR_2_COMMENTADDR_3_CITYADDR_3_STREETADDR_3_HOUSEADDR_3_APPARTMADDR_3_COMMENTIf the client has more than three addresses then you need to fill the last three addresses in the ADDS_KOD sample the first three to eliminate.The example KOD - 3529935 29930 860Goloseevsky (40-year October) prosp.130/5799pod.3, et.5, dop number 0968080048 VladislavKiev35 29943 619Ovanesa Tumanjana ul.15 A455Sector E, floor 14Kiev35 29943 375Nikolaja Bajana prosp.8 b19419 eKiev35 29951 246Saperno-Slobodskaya ul.8169p.3 et.2 delivery from 400Kiev35 29930 712Boris Gmiri ul.411417 et,Hinkali TEL 10 st Bespl + Hachap in gift,Jaloba 12,04,18Kiev35 29948 193Saperno-Slobodskaya ul.8169p.3 et.2 shift from 900Kiev353 294953Slobodskaya ul. take ADDS_KOD the first three on loss - 53364, 51246, 48193 The customer table will include data on these three addresses. There are things that are not repeated, there are things that are not repeated.and will get in the client table for the KOD 35299 will be such a recordKODADDR_1_CITYADDR_1_STREETADDR_1_HOUSEADDR_1_APPARTMADDR_1_COMMENTADDR_2_CITYADDR_2_STREETADDR_2_HOUSEADDR_2_APPARTMADDR_2_COMMENTADDR_3_CITYADDR_3_STREETADDR_3_HOUSEADDR_3_APPARTMADDR_3_COMMENT35 299KievSapernovo-Slobodskaya8169p.3 et.2KievSapernovo-Slobodskaya ul.8169p.3 ed.2 of 400KievSapernovo-Slobodskaya ul.169p.3 ed. This is the case for the entire customer table.Link to the tables https://drive.google.com/file/d/1ZHkNNdICmxcw1ot3E_14xfp3lqwPq6ax/view?usp=sharing https://drive.google.com/file/d/1B4PP2Au7lsBKVNzWMBq6BymQcb4oJsUq/view?usp=sharing

Proposals 5

Pavel Svetlan

Winning proposal

58 0

Projects 41
Rating -
Rating 291

Budget: 600 UAH Deadline: 1 day

Ready to do within 2 hours, I can start immediately after approval.
Payment is possible directly on the fact of execution

Oleksandr Grib

19 1

Projects 19
Rating -
Rating 227

Budget: 500 UAH Deadline: 2 days

Good day . I write a macro to process the input table according to your requirements. Details/ Term to clarification.

Igor B.

85 0

Budget: 800 UAH Deadline: 1 day

Готов сделать.
оооооооооооооооооооооооооооооооооооооооооооооо

The list does not show proposals concealed by the client or freelancer with a Plus profile, as well as proposals violating rules

Current freelance projects in the category Databases & SQL

Automation of the entry of income invoices in 1C 8.3 via the API of the document recognition service

13 proposals 0:36

335 USD
Updating Joomla version

Content Management Systems 29 proposals 5 August

16 USD
Senior AI Systems Architect (Project Lead) Needed to Complete an Existing Unfinished Global Service

Gaming Apps 19 proposals 3 August

Not specified
Development of the CRM module "Requests" in custom 1C (bus center)

Client Management & CRM 20 proposals 31 July

Not specified
Support for Samotur and its servers

17 proposals 27 July

22 USD

Vladimir Aganesyan
Kyiv, Ukraine

Projects 12
Rating -
Rating 290

Vladimir Aganesyan

Pavel Svetlan

Pavel Svetlan

Oleksandr Grib

Igor B.

Proposals are currently absent

Current freelance projects in the category Databases & SQL

Automation of the entry of income invoices in 1C 8.3 via the API of the document recognition service

Updating Joomla version

Senior AI Systems Architect (Project Lead) Needed to Complete an Existing Unfinished Global Service

Development of the CRM module "Requests" in custom 1C (bus center)

Support for Samotur and its servers