Find Jobs
Hire Freelancers

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

$30-250 USD

Completed
Posted about 5 years ago

$30-250 USD

Paid on delivery
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 ****
Project ID: 18986394

About the project

29 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 other similar files. Looking forward to have a positive response from you. Thanks
$60 USD in 1 day
5.0 (216 reviews)
7.5
7.5
29 freelancers are bidding on average $122 USD for this job
User Avatar
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. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$150 USD in 2 days
5.0 (238 reviews)
7.8
7.8
User Avatar
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 Table field" to "Properties table" file right. Please send me message, so I will send sample file to you.
$150 USD in 3 days
5.0 (150 reviews)
7.4
7.4
User Avatar
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 macro that will automate this process for you. I'm among the most experienced, and skilled Excel, and VBA developers on this platform. I have completed over 290 projects successfully in six years, and I feel confident in achieving your task as well. You're welcome to visit my page (https://www.freelancer.com/u/paris2785) and get an idea of who I am and what services I provide to my clients. I will charge you $150 and can deliver within five days (a single milestone to release once you're satisfied with the final result). I'm online from 8 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas
$150 USD in 5 days
4.9 (168 reviews)
7.2
7.2
User Avatar
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 in 3 days
5.0 (38 reviews)
6.8
6.8
User Avatar
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 second. I do have couple of questions on the specific requirements that I would bring up when wee have our discussion. Being a full time freelancer working exclusively on Excel based projects, I work on developing macros every single day. I have 18 years experience in using Excel as part of my daily work life. Over the last 25 MONTHS , I have spent at least 250 HOURS on automation in Excel every month. Have a Great Day! Srinivasan Krishnamoorthi
$80 USD in 2 days
5.0 (103 reviews)
6.4
6.4
User Avatar
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, WordPress template & plugin, WooCommerce. I am able to combine 2 CSV files with primary key "Matrix Unique ID" I am ready to discuss and start now. If I am chosen for this project, I commit preparing the development site and updating project status daily or whenever you message me. Thank you for your consideration. I am looking forward to your reply. Sincerely, Khoa
$200 USD in 3 days
5.0 (39 reviews)
6.3
6.3
User Avatar
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. Please ping me to have a further discussion. Thank you.
$155 USD in 3 days
5.0 (9 reviews)
5.7
5.7
User Avatar
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, Manish
$120 USD in 5 days
4.9 (67 reviews)
5.4
5.4
User Avatar
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 in 3 days
4.9 (14 reviews)
5.6
5.6
User Avatar
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 records perform next activity and if you require can export to csv format again or store to a different table and can remove previous 2 tables if not required. Please let me know if you feel my approach better. Or, let me know insight of your business idea so that I can re-think about the solution architecture. Looking forward for your reply. Thanks & Regards, Anshulika Bansal
$90 USD in 1 day
5.0 (32 reviews)
5.3
5.3
User Avatar
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 me Regards
$50 USD in 0 day
4.9 (31 reviews)
5.1
5.1
User Avatar
Dear Sir/Madam, I have understood your requirements. Ready to start ***************************************************************
$45 USD in 1 day
5.0 (15 reviews)
4.8
4.8
User Avatar
I am a database / Business Intelligence architect and having more than 14 years of experience in IT industry. The best solution for your requirement is SSIS tool. where I will load your both CSV data and then do some transformation and then achieve required result.
$250 USD in 3 days
5.0 (27 reviews)
4.9
4.9
User Avatar
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 automated bid and I am available right now to discuss your project! Khalid.
$150 USD in 3 days
5.0 (7 reviews)
3.8
3.8
User Avatar
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 web development services and complete the site in time. Please contact with me. Thank you very much.
$55 USD in 3 days
4.3 (14 reviews)
4.1
4.1
User Avatar
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 in following data entry areas: - Image to MS Word/Spreadsheet, - Email Handling, - Web Research, - Customer Research, - Data Entry on Excel Spreadsheets, I do available 16 hours a day so you get the quick response on chat and work. I assure you the 100% guarantee on work quality. Thanks & Regards, Nisha D.
$155 USD in 3 days
5.0 (3 reviews)
2.8
2.8
User Avatar
Hi, We have been working on excel files and data since last 8 years now. We are experienced in writing excel VBA codes as well. We have gone through the TEXT files attached by you and copied it to excel file to understand the exact requirements. We could understand some portion of it but you could explain the requirements we could probably to able to get the work done either manually or through a VBA code. Hoping to work on this project. Thank you.
$55 USD in 3 days
5.0 (5 reviews)
2.6
2.6
User Avatar
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 combined data in a single table or a single Excel or CSV file, it's up to you to decide Do not hesitate to contact me to be able to exchange on it, Cordially
$50 USD in 3 days
5.0 (3 reviews)
2.2
2.2
User Avatar
Hi! my name is Amit. I am an experienced Full Stack developer. I have read the project requirements carefully and I have understood the project requirements. I am very much interested in your project. I can start work right now. For further clarification you may ping me.
$150 USD in 3 days
5.0 (2 reviews)
1.8
1.8
User Avatar
Hello, I am very interested by your offer. I have long experience using MS ACCESS and developing queries, please try me. Looking forward to work with you. Thanks and regards.
$30 USD in 1 day
5.0 (2 reviews)
1.4
1.4

About the client

Flag of UNITED STATES
Houston, United States
4.8
102
Payment method verified
Member since Mar 5, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.