Data Transformation - horizontal embedded tables into child tables

The attached file is a sample output of a database that needs to be transformed into a normalized table of data. Instead of the source being a table of data with children records, it was given to me with all child records pivoted horizontally. So it is a very wide table of data that must be broken into a narrower table with several related tables. A detailed explanation is provided below, as well as a sample of the transformation that needs to occur (second tab of the sample output).

In order for your proposal to be accepted, I require the following:

1. Timeline

2. Fixed cost

3. Description of the approach to how you will transform the data (i.e. what coding language)

4. Assumptions you are making regarding your approach

More specific project requirements are listed in the Google doc below in detail. I will fund 50% of the escrow upon rewarding the job. The remaining 50% will be released upon my satisfaction of the requirements below being met.

[url removed, login to view]

Evner: Databehandling, Database Administration, Programmering af database, MySQL, Software Arkitektur

Se mere: software project proposal sample, sample proposal for job, sample proposal document for a project, sample of the proposal, sample of the project proposal, sample of requirements document, sample of proposal of project, sample of project proposal, sample of job proposal, sample of a job proposal, sample job proposal, proposal of project sample, horizontal architecture, what is a google doc, google document sharing, google docs sharing, google docs cost, escrow fund, embedded coding, google docs mysql, embedded project coding, horizontal timeline, software architecture proposal, embedded coding project, mysql output table

Om arbejdsgiveren:
( 0 bedømmelser ) Nepal

Projekt ID: #6027577

16 freelancere byder i gennemsnit $455 på dette job


I have read your requirement in spreadsheet shared and I believed that I can build this application for you in 1 day. I will C# to build this application and accept many type of excel file such as csv, xls, xlsx. feel Flere

$250 USD in 3 dage
(27 bedømmelser)

Hi, I have been working as Database Analyst Programmer more than 10 years. I became OCP, CCNP, RHCE 3 years back. Earlier I completed B.Sc. Enng and M.Sc. Engg both in computer engineering. Check my works here h Flere

$333 USD in 7 dage
(67 bedømmelser)

Hi, I have lots of experience with databases and can help you in short terms with this project. I checked the spreadsheet for information, but can you share the data which need to be changed so I can work on it and sho Flere

$555 USD in 7 dage
(11 bedømmelser)

Hi, I am a database programmer and work with php and mysql. I found this project interesting and am researching it. What is not clear are the exact relationship between a property detail and the cell number (example A Flere

$275 USD in 10 dage
(6 bedømmelser)

Hi, I do this for a living :) To be sure, here is an app I quickly made that uses your data from the link to normalize - of course it needs more testing and features, it was just a proof-of-concept and hopefully sho Flere

$291 USD in 10 dage
(1 bedømmelse)

Hi there! Listen, I have already done the program, just missing the SQL part, thats why I can have it ready in 1 day. I downloaded a csv version of the sheet you have in google documents and I worked with it. Fo Flere

$498 USD på 1 dag
(2 bedømmelser)

Hi, Greetings for the day, we have gone through the data provided by you and would like o bid on this project , Time line will be 15 Days , Fixed cost is 555 USD , Approach , will try to create a macro in Ex Flere

$555 USD in 15 dage
(0 bedømmelser)

A proposal has not yet been provided

$555 USD in 10 dage
(0 bedømmelser)

A proposal has not yet been provided

$333 USD in 10 dage
(0 bedømmelser)

I currently extract non-normalized data from car dealers' DMS systems on a weekly basis and update a MySQL database. The major difference here is that I must assume that each new input file is a different format and I Flere

$833 USD in 10 dage
(0 bedømmelser)

A proposal has not yet been provided

$555 USD in 10 dage
(0 bedømmelser)

Dear Sir : I was excited when I saw your job postings online for data entry person. I have three years of data entry experience, and I have performed all of the duties listed in your job description. I type 42 wpm w Flere

$388 USD in 10 dage
(0 bedømmelser)

Hello, I found your job advert and I like to apply for the job. I have professional experience in excel/table computing. I have worked for various organizations like provision stores, pharmacies, government organizati Flere

$555 USD in 3 dage
(0 bedømmelser)

Hello sir. I have an expirience in data transformation, I can solve this task in Python language, and I'd like to work with you. Regards, Alexander

$277 USD in 4 dage
(0 bedømmelser)

I am a Technologist, with emphasis in Databases. I have experience as an Architect, Administrator, and Developer. Therefore, I have the knowledge to build and support Enterprise Database Systems from the ground up. I h Flere

$750 USD in 14 dage
(0 bedømmelser)

I am here to deliver beyond your expectations. I am an experienced of Data Entry and Data Processing and so my other services that will provide useful benefits to your project. I have a distinguished career as a Copy T Flere

$283 USD in 10 dage
(0 bedømmelser)