Synchronization of data between two tables.

This is the platform table.
Column O contains names in different languages and some of them may consist of 3-4 words.
Column H represents the amount in currency, and there should be a second stage of verification according to this amount.
Column F is the currency.

This is the bank table.
The synchronization task is as follows:
We take each payment in turn, look at column A (date), B (transaction type, incoming or outgoing), C (contains information about the sender or recipient including the name), column D (amount of currency), column E (currency).
And accordingly, we need to find in the platform table the row with the corresponding amount and name considering that the names need to be adapted. If it matches, then in the platform table, we need to transfer the date from the bank table column A to column S.
I would like to emphasize that the key is to find a solution for the correct synchronization of names.
The full names are indicated in the platform statement in different languages, there may be different orders of surname and name, or they may consist of 4-5 words. In the bank statement, they are mostly indicated in Latin letters, but there are some exceptions.
-
310 Hello!
The task is clear — I can start right now. I have experience in reconciling data from various sources, including taking into account variations of names in different languages and formats.
I guarantee accurate matching by names, amounts, and currency. After finding the match, I will transfer the date from the bank statement (column A) to column S of the platform table, as specified.
If needed, I can also add automation or checks.
-
834 8 0 The approximate logic is as follows:
1. bring to a single format (Latin/Cyrillic, word order, extra spaces).
2.1 Compare the payment amount (H in the platform and D in the bank).
2.2 Match names (O in the platform and C in the bank) considering variations.
2.3 Check the currency (F in the platform and E in the bank).
3. if the record is found, transfer the date (A from the bank → S in the platform).
4. Save the result
…
But we need to take a closer look at the tables themselves to see their scale and to see how strong the discrepancies are. You can write to me privately to discuss the details; the price is not final and can be lower or higher. It all depends on additional details.
-
571 6 1 1 Hello, Katerina!
I am ready to help with the synchronization of data from two tables. My goal is to correctly match names and amounts from both tables, taking into account linguistic and structural differences. I will develop an algorithm that adapts the names and ensures accurate correspondence, as well as transfer dates to the required column. With over 3 years of experience, I guarantee high quality and quick implementation.
I look forward to the opportunity to collaborate!
-
1026 15 0 Good day.
I have experience working with Excel.
I need to look at the data in both tables to suggest an implementation option.
-
726 9 1 Hello! I have reviewed your project and am ready to start working immediately. I guarantee excellent quality and promptness.
-
Шукати "огирки" по "помідорам" ....
Навіть якщо прикрутити АІ то гарантій що імена будуть коректно адаптовані немає. Якісь треба інші засоби співставлення наприклад ІD, чи хочаб по часу.
-
Мені здається що там і людина не завжди розбереться де чий платіж, якщо шукати лише за іменем, яке написано як-завгодно...
Гарантію ніхто не дасть на 100% співставлення. Я б порадив розглянути інший підхід
-
Current freelance projects in the category AI & Machine Learning
Create an AI video clip
45 USD
Generate a video clip from the rendering of a building using the object photo according to the reference and with a stunning scenario. There is a developed test prompt that needs to be refined. Possible neural networks for generation: King AI, Runway, Luma, Google AI Pro, Google… AI & Machine Learning ∙ 20 hours 23 minutes back ∙ 16 proposals |
AI Automation Engineer
22 USD
Need an AI Automation Engineer, a specialist for creating a system for active client search and smart outreach (not a regular chatbot-autoresponder) for a B2B project Data collection: automatic parsing of contacts from "blind" databases by name. Smart mailing: integration… AI & Machine Learning, Embedded Systems & Microcontrollers ∙ 22 hours 41 minutes back ∙ 13 proposals |
Development of a high-load system with fine-tuning of LLM modelsDevelopment of a high-load system with fine-tuning of LLM models for an online service of multimodal product search by photo and text query simultaneously integrated into messengers through a personal agent-assistant. AI & Machine Learning ∙ 1 day 7 hours back ∙ 16 proposals |
Need a developer to create an automated AI service for generating numerology reports.
178 USD
I'm looking for a developer who can implement a turnkey automated service for generating personal numerology reports. A product concept, calculation formulas, texts, knowledge base, landing page design, and PDF report design are ready. It is necessary to combine all this into… AI & Machine Learning, Web Programming ∙ 1 day 10 hours back ∙ 72 proposals |
Need an AI photoshoot for a dating site and social media (10 photos)Need an AI photoshoot for a dating site and social media (10 photos) Looking for a specialist in AI generation, retouching, and photo montage to create a realistic photoshoot based on my photographs. What needs to be done: Create 10 high-quality and as realistic as possible… AI Art, AI & Machine Learning ∙ 1 day 20 hours back ∙ 31 proposals |