Data Analysis - Map Source Columns to Target Columns
$30-250 USD
Paid on delivery
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
Project ID: #16955609
About the project
Awarded to:
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 freelancers are bidding on average $129 for this job
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 More
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 More
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 More
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 More
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 More
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 More
Dear I will complete your work in 3 days Check me Relevant Skills and Experience I am new
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.
