Google Sheets (May be Google Sheets)
9 USD SELECT project, url1, NULL as product_id
From the post_1
WHERE ID IN (SELECT ID FROM_2 GROUP BY ID)
Group by project, url1
The product_id field will be filled manually on the basis of url1 and url2 data.2) Based on the data in tables 1 and 3, it is necessary to form a tab_4 which will contain all filled manual product_id from tab_3 and the corresponding ID from tab_1.The key to the data combination should be the field url_1.In SQL, this procedure can be expressed.in the way:
SELECT t1.product_id and t2.id
(SELECT product_id, url_1 FROM entrance_3 GROUP BY product_id, url_1) t1
The Left Join
(SELECT url_1 , id from the tab_1) t2
ON t1.url_1 = t2.url_1
Client's review of cooperation with Aleksandr Pomazun
Google Sheets (May be Google Sheets)The work is done quickly and with a description of the solution.
Freelancer's review of cooperation with Sergey Ivanov
Google Sheets (May be Google Sheets)Everything went well,
satisfied with joint work.
-
1 day11 USD
1756 38 0 1 day11 USD
Hello to you.
Ready to do and, if necessary, to explain.
Go to turn.
-
Можно увидеть тестовый пример файла?
-
Current freelance projects in the category Databases & SQL
Power BI
16 USD
The dashboard runs on a Google server, we need to transfer all logic + code Required skills: deployment of ETL processes on a Linux server + working with BigQuery and Postgre There is working code that runs on Google, where the database itself is, we need to transfer it to… Python, Databases & SQL ∙ 8 hours 59 minutes back ∙ 11 proposals |
Need a 1C specialist for refinements and development.I am looking for a 1C specialist for freelance collaboration. I am currently working with a contractor who provides support and maintenance for the 1C system. However, due to the contractor's workload, there is a need for prompt execution of additional tasks, improvements, and… Databases & SQL ∙ 2 days 8 hours back ∙ 11 proposals |
Restoring Instagram after a banOn March 3, 2026, my Instagram was blocked due to a violation of rules. I believe there has been some mistake, as the page was personal with photos and videos of my personal trips. I did not post any comments anywhere. I have sent several appeals. I cannot download my files… Databases & SQL, Web Programming ∙ 2 days 19 hours back ∙ 5 proposals |
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 6 days 2 hours back ∙ 16 proposals |
Accounting, planning, and sales system for a mushroom farm
601 USD
Here is the complete, final text of the Technical Assignment (TA). It combines all your requirements: 16 chambers, 20 contractors, a schedule by days, accounting for containers, profitability calculation, and a mandatory division into three grades of mushrooms. You can fully… Databases & SQL, Client Management & CRM ∙ 8 days 6 hours back ∙ 61 proposals |
Kyiv