Data Analysis - Map Source Columns to Target Columns
$30-250 USD
Dibayar saat pengiriman
I need a provider who can help me map columns from source files to a target file. The source files columns are labeled differently from the Target Columns so I need a provider to evaluate each source column and try to find a matching target column. This can be done by matching the data from the source column to the data in the target file. Please read instructions carefully and see the bonus eligibility criteria below.
EXCEL Document (see attached).
1. There are 5 source files each in a worksheet labeled "Source File".
2. There is one worksheet containing the Target Data labeled "Target Data". Each record in the target
file is linked to the source file by the UPC column.
3. There are 5 source mapping worksheets labeled "Map for Source File...".
4. There is 1 worksheet to identify all target columns that could not be mapped to source columns.
Instructions:
1. For each worksheet labeled "Source File" match each column to a column in the worksheet label
"Target Data". To identify a match, you will take a value the source file (ex., UPC - 27557121255)
and then search for this value in the target data worksheet.
2. Document mapping rule in the worksheet labeled "Map for Source File". Each Map Source File
worksheet contains the following columns.
A. Source - this will be column from the source file. ex., Catalog Number
B. Target - this will be the column from the target data files. ex., [login to view URL]
C. Source Data Example - This will be a sample value from the source file. ex., AY-103P-AL
D. Target Data Example - This will be a sample value from the target file. ex. LAY103PAL
E. Transformation Rule - This will be the rules to transform the source column to target column.
You do not have to fill this out.
3. Mapping Rules to follow:
a. If a source column maps to multiple target columns, then repeat the row. For example:
Source Column Target Column
------------------------ ----------------------
Catalog Number [login to view URL]
Catalog Number MFG_PART_NUM
b. Please be aware that a source column value will not always match identically to a target value.
For Example:
Source Value Target Value
--------------------- --------------------
AY-103P-AL LAY103PAL
c. The target file only contains 170 records of the source file.
d. When you complete the mapping for each 5 source files, then identify all the columns from the
target file that were not match to source columns. See worksheet "Target Columns Not Match".
Provider Qualifications and Expectations:
1. Must have EXCEL experience
2. Must be very detailed oriented and Thorough
3. Must complete all 5 Source Mapping Worksheets
4. Must complete the "Target Columns Not Match" worksheet
Bonus Eligibility:
1. Based on the number of matches found between the source and target.
2. Early completion bonus.
3. 5$ additional dollar bonus for each match of a column that does not have the identical value (cap
$50.00). Unique column matches only. Some columns are the same in source files. for
example
Source Value Target Value
--------------------- --------------------
AY-103P-AL LAY103PAL
ID Proyek: #16955609
Tentang proyek
Diberikan kepada:
Hello, You need help to match column labels of 5 source files with Target Data. I will do this with accuracy. I'm ready to start. Best regards, Hoang
25 freelancer rata-rata menawar $129 untuk pekerjaan ini
Hi I am a very experienced statistician and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have d Lebih banyak
Hi, I checked the sheet and details. If my understanding is correct we have to do column mapping between 4 source files and 1 target file. I can do that easily for you as I have experience in Excel. Please check th Lebih banyak
Greetings for the Day!!! I have 8 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Serv Lebih banyak
A dedicated analyst, proficient in running successful method-oriented operations & taking initiatives for business excellence. Specialized in creating Predictive modelling of data using supervised (Machine Learning) an Lebih banyak
Hi, I can do this job for you. I have done it many times and I am professional in it. Will give you the work as per your requirements and according to your satisfaction. Deliver it on time and with quality work. Wai Lebih banyak
I am a computer engineer with high skills about a lot of iT related things. I know Office and other Microsoft programs inside out. As well as Google services. I have a google certification for their platform. I can do Lebih banyak
Hello, After reviewing this project and the attached files, I am confident that I can complete this work for you! Please refer to my profile which highlights my experience and expertise in Microsoft Excel as directl Lebih banyak
Hello, Click on the [CHAT] button below so that I can ask a few questions concerning your Data Analysis - Map Source Columns to Target Columns project. I have read all the provided instructions, and I am the right pe Lebih banyak
I am hardworking, enthusiastic, pro active, disciplined and orderly, honest, responsible, I have worked from administration of data entry and exit, as a bilingual teacher, selling shoes in Honduras, and I help teachers Lebih banyak
Dear I will complete your work in 3 days Check me Relevant Skills and Experience I am new
Greetings, I hope this message finds you well. I'm willing to work on your project dedicating my mindset into the time of work planned, it will be such an honor getting my first online freelancing job through you. Eage Lebih banyak
Looks pretty straight forward. Very familiar with fulfilling these types of projects from past experience working as a business analyst for CSX Transportation. Relevant Skills and Experience Advanced Excel
I work as a BI Developer and I have a strong knowledge of data analysis. I can use excel and different BI/ETL tools to shorten the time.