Find Jobs
Hire Freelancers

Data Transformation - horizontal embedded tables into child tables

$250-750 USD

Cerrado
Publicado hace casi 10 años

$250-750 USD

Pagado a la entrega
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. [login to view URL]
ID del proyecto: 6027577

Información sobre el proyecto

16 propuestas
Proyecto remoto
Activo hace 10 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
16 freelancers están ofertando un promedio de $455 USD por este trabajo
Avatar del usuario
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 free to contact me then I will consult you how to do and use this application.
$250 USD en 3 días
4,8 (28 comentarios)
6,1
6,1
Avatar del usuario
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 https://www.freelancer.com/projects/Software-Architecture-Engineering/Entity-Relationship-Diagram-ERD.html https://www.freelancer.com/projects/PHP-HTML.1/Database-Project.html https://www.freelancer.com/projects/database-administration/Database-Coursework.html I'm looking forward to hearing from you very soon
$333 USD en 7 días
4,5 (67 comentarios)
5,9
5,9
Avatar del usuario
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 show you results quickly? I'm proposing to do this with VBA and excel macro which will be more handy than any executable code and is easy maintainable for the future.
$555 USD en 7 días
5,0 (12 comentarios)
4,7
4,7
Avatar del usuario
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.12. A.13) in the column name. If you can help make sense of the column name then the relationships can be coded and the tables formed recursively. If you make this a hourly project then I can work for $20 per hour for a max 10 hour per week for 2/3 weeks. If you have any questions please let me know and I will be happy to answer them. Thanks Deb
$275 USD en 10 días
4,6 (6 comentarios)
3,8
3,8
Avatar del usuario
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. For the 2500 fields capacity, I develop a function that reads a field a a time, and then use it to develop a function that reads and entire line returning and array with all the fields in the line. Just as an example of the data structures the program construct with the headers of the csv fie: [A.11] => Array ( [head] => TYPE CODE(A.11) [start] => 10 [end] => 12 [records] => 3 ) [A.12] => Array ( [head] => PACKAGE NUMBER(S)(PHOTO LOG)(A.12) A.12,A.13 [start] => 13 [end] => 31 [records] => 19 [rel_num] => 0 ) So if you choose me you got almost intant delivery of a tested and verified program and a low price whithin yuor budget. What I ask for is to rate me high, comment and whatever you can do to increase my reputation on freelancer.com as I'm new. As you can see on my profile, this will be my 2nd project and you can read the feedback of my 1st employer. By the way, I'm flexible and open to hear proposals.
$498 USD en 1 día
5,0 (2 comentarios)
2,3
2,3
Avatar del usuario
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 Excel to have the desired result , Assumption 1- The data table will remain constant .IE Column will not be changed also you are looking Creating a new tab in Excel with PROPERTY ID as the first column, then A.12 and A.13 as the next columns and if there is no data you want to skip that row , Just wanted to know how many row and column are you looking at for conversion Thanks for your kind consideration Best Regards Micoline BD team
$555 USD en 15 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$555 USD en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$333 USD en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 need to identify the non-normalized data from the header record. 1. Timeline - 10 days from award of bid and delivery of a real input file 2. Fixed cost - $750 (includes a week of support) paid upon completion 3. Description of the approach to how you will transform the data (i.e. what coding language) VB program will read header record, decide which fields are non-normalize and map how to output the new data. Output will be provided in CSV and SQL (insert commands). I propose SQL syntax that is standard and that I can check with MySQL. 4. Assumptions you are making regarding your approach The input data is in CSV format and that each row is a complete record (a data item is not split into multiple rows). Langston
$833 USD en 10 días
0,0 (0 comentarios)
3,8
3,8
Avatar del usuario
A proposal has not yet been provided
$555 USD en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 with almost 100% accuracy, and my employers have praised me for my focus, speed, accuracy, and professionalism. I hope these are qualities you look for in your data entry employees. I am looking forward to discuss you further on chat where we can discuss the open positions in more detail, and you can ask any questions you may have. Please schedule a time to meet. Thank you I look forward to meeting you. Sincerely, Rahul Gupta
$388 USD en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 organizations, researchers and private sectors on data collection in tabular arrangement and analysis. I have a very fast typing skill and would be able to get your job done in a short period of time. I assure you that I will give you my best. I am open to any question or interview you may have for me or concerning my skills. I look forward to giving you my best services and getting a recommendation from you at the end of the day. Thank you, Akanbi, M.O.
$555 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 4 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 have many years of experience building Reporting Systems, from operational reports to cubes to dashboards. This includes designing databases, developing ETL systems, and coding reports, such that it supports business processes to easily store data and transform into custom reports.
$750 USD en 14 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 Typing and Editing Expert. I can comfortably handle Data Entry, web scraping, Data Processing and Editing. I also hold experience in Excel and Data Base. I am ready to be hired by you and start work today
$283 USD en 10 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de NEPAL
Nepal
0,0
0
Miembro desde jun 2, 2014

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.