Suoritettu

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 ****

Taidot: tietojenkäsittely, Tietokantakehitys, Tietokantaohjelmointi, SQL

Näytä lisää: 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

Tietoa työnantajasta:
( 84 arvostelua ) Houston, United States

Projektin tunnus: #18986394

Myönnetty käyttäjälle:

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 Lisää

$60 USD 1 päivässä
(173 Arvostelua)
7.1

34 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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 ( Lisää

$200 USD 2 päivässä
(380 arvostelua)
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. Lisää

$150 USD 2 päivässä
(181 arvostelua)
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 Lisää

$150 USD 3 päivässä
(143 arvostelua)
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 Lisää

$150 USD 5 päivässä
(108 arvostelua)
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 Lisää

$80 USD 2 päivässä
(70 arvostelua)
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, Lisää

$200 USD 3 päivässä
(38 arvostelua)
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. Lisää

$155 USD 3 päivässä
(8 arvostelua)
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 Lisää

$120 USD 5 päivässä
(60 arvostelua)
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 päivässä
(18 arvostelua)
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 Lisää

$90 USD 1 päivässä
(15 arvostelua)
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 Lisää

$50 USD 0 päivässä
(18 arvostelua)
4.5
FreelancerTechX

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

$45 USD 1 päivässä
(3 arvostelua)
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 Lisää

$155 USD 3 päivässä
(6 arvostelua)
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 päivässä
(4 arvostelua)
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 Lisää

$150 USD 3 päivässä
(7 arvostelua)
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 Lisää

$70 USD 1 päivässä
(11 arvostelua)
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 Lisää

$55 USD 3 päivässä
(10 arvostelua)
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 Lisää

$155 USD 3 päivässä
(3 arvostelua)
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 Lisää

$50 USD 3 päivässä
(1 arvostelu)
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 Lisää

$45 USD 3 päivässä
(0 arvostelua)
0.0