Виконано

Combine 2 CSV files with Primary Key = Matrix Unique ID to Child "Table MUI"

Combine 2 csv files attached to project

Properties table primary key = "Matrix Unique ID" to match = Media Table field "Table MUI

For each match in Media table add TO a field named "MediaURL (new field in properties table " seperate with an * each value

***** THIS IS SAMPLE DATA ATTACHED BUT ONCE SUCCESSFUL I WILL GIVE REAL DATA ****

Навички: Обробка даних, Розробка баз даних, Програмування баз даних, SQL

Деталі: vbscript parse csv files, plotting csv files excel, google base csv files, net csv files parse, scripting reading csv files, uploading csv files xcart, csv files can run unix, merge files using primary key, combine csv files, compare 2 csv files php, how to combine two csv files in shell script, python combine two csv files, combine multiple csv files into one excel workbook, combine multiple csv files into one workbook separate sheets, mysql 5.7 all parts of a primary key must be not null; if you need null in a key, use unique instead, compare 2 csv files for differences powershell, how to combine 2 flp files, combine csv files without duplicating headings using c#, combine multiple csv files into one r

Про роботодавця:
( 84 відгуки(-ів) ) Houston, United States

ID Проекту: #18986394

Доручено:

sumon355

Hello, As an experienced software developer and having sound knowledge in processing csv files, i am very much interested to provide you a windows application to do this task. Later you can use this program to process Більше

$60 USD за 1 день
(173 відгуків(-и))
7.1

34 фрілансерів(-и) у середньому готові виконати цю роботу за $118

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Більше

$200 USD за 2 дні(-в)
(380 відгуків(и))
7.8
schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Більше

$150 USD за 2 дні(-в)
(181 відгуків(и))
7.5
nikhil08

Hi there, I have experience of matching the fields & updated the details in other file. I have checked both files. if "Table MUI" field & "Matrix Unique ID" field match, I have to take all remaining fields from "Media Більше

$150 USD за 3 дні(-в)
(143 відгуків(и))
7.4
paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have two CSV files combined based on Matrix Unique ID. I will write the required macr Більше

$150 USD за 5 дні(-в)
(108 відгуків(и))
6.6
ksriniravi

Greetings! I can write a macro to automate the process of looking up using primary key and adding a new field. So, whenever you have such requirements, you can get the required actions completed at the click of a se Більше

$80 USD за 2 дні(-в)
(70 відгуків(и))
6.1
tranngocanh1702

Hi, I am Khoa with more than 7 years experience in web and cross-platform app development including Hybrid, PHP, Laravel framework, Slim, CodeIgniter, MySQL, PostgreSQL, HTML, CSS, Javascript, jQuery, Vuejs, Ajax, Більше

$200 USD за 3 дні(-в)
(38 відгуків(и))
6.1
TenStar718

Hello, how are you? I have gone with your description carefully. I have developed several applications similar to yours. One of them is Document auto-creator from XML. I am sure I can finish your work successfully. Більше

$155 USD за 3 дні(-в)
(8 відгуків(и))
5.5
softcarve

Hi, I have checked the attached files. I would like to combine the csv according to the tables in the database. Please share the table structure as well. Available for discussion and ready to start now. Regards, Ma Більше

$120 USD за 5 дні(-в)
(60 відгуків(и))
5.4
Agiletechstudio

Hi there, Sir i read your initial requirements and i have some question regarding to your csv project. please send me message so that we could discuss it further.

$100 USD за 3 дні(-в)
(18 відгуків(и))
5.0
anshulikabansal

Hello Sir, After looking at the data and your description, I have a solution for this: Step1: Import both csv into database individually Step2: Perform a join and find out the matching records Step3: using this r Більше

$90 USD за 1 день
(15 відгуків(и))
4.5
usman1493

Hello Sir A Database expert developer is here I have good advanced expertise in database design is here I have good advanced expertise in database design and development This is an initial bid Feel free to message Більше

$50 USD за 0 дні(-в)
(18 відгуків(и))
4.5
FreelancerTechX

Dear Sir/Madam, I have understood your requirements. Ready to start ***************************************************************

$45 USD за 1 день
(3 відгуків(и))
3.7
artemu1223

Hi, there! Highest quality and fastest delivery are promised. First of all please take a look my profile and awesome reviews from my clients. I fully understood your job description and I am pretty interested in y Більше

$155 USD за 3 дні(-в)
(6 відгуків(и))
3.8
chrisvwn

Hi, I can build the SQL commands required to populate "MediaURL" with a combination of data based on matching values in Properties."Matrix Unique ID" = Media."Table MUI".

$155 USD за 3 дні(-в)
(4 відгуків(и))
3.9
kmpal

Hi, I am a developer with vast experience in .NET, MVC, SQL, Java/TypeScript, Angular, PHP available for this project. I am full time freelancer available throughout the day. Best regards Note: This is not an Більше

$150 USD за 3 дні(-в)
(7 відгуків(и))
3.8
dungchan44

Hello, sir! I am happy to put my bid on your project. I have a full of experience with database development and management. I have finished a lot of projects like this. I can show you one of them if you want. I en Більше

$70 USD за 1 день
(11 відгуків(и))
3.6
kipdev13

Nice to meet you. I've read the project description and definitely can develop this. I'll provide you with the highly skilled & professional HTML/CSS, PHP/WordPress/CodeIgniter, JavaScript, MySQL, front & back-end we Більше

$55 USD за 3 дні(-в)
(10 відгуків(и))
3.6
nishajaryal37

Hello there, I am Nisha(Data Entry Expert) with experience of more than 5 years. I worked for multiple clients internationally and made them happy by providing them more than their expectations. I have expertise Більше

$155 USD за 3 дні(-в)
(3 відгуків(и))
2.8
MedMESTIRI

Hello, I am interested in your project and I have a good experience in SQL, SQL Server & Access. I can create either an SQL script or a small application (Exe for Windows Desktop) that allows you to have the combin Більше

$50 USD за 3 дні(-в)
(1 відгук)
0.8
jonathanua81

Greetings, I would like to participate in your project and give solutions to your needs. I offer my expertise in migration of information from flat files to database structure. I will be attentive to your comments or Більше

$45 USD за 3 дні(-в)
(0 відгуків(и))
0.0