Data Analysis - Map Source Columns to Target Columns

已完成 已发布的 5 年前 货到付款
已完成 货到付款

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

Data Analytics 数据输入 数据挖掘 数据处理 Excel

项目ID: #16955609

关于项目

25个方案 远程项目 活跃的5 年前

授予:

hdlong66

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

$100 USD 在3天内
(164条评论)
7.0

有25名威客正在参与此工作的竞标,均价$129/小时

suyashdhoot

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 更多

$250 USD 在3天内
(97条评论)
6.9
caabdul

Hi there, let's discuss and complete the job. Thanks

$100 USD 在3天内
(63条评论)
6.3
TechnoGuruu

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 更多

$100 USD 在3天内
(96条评论)
6.2
sonarkaushik

I am very able to match and nap source and target columns. I am ready to start regards

$99 USD 在2天内
(104条评论)
6.3
prabakarm23

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 更多

$111 USD 在3天内
(50条评论)
4.7
raghavajay3

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 更多

$155 USD 在3天内
(9条评论)
3.9
wiisetech

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 更多

$55 USD 在3天内
(43条评论)
4.3
MissCrissy

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 更多

$35 USD 在3天内
(6条评论)
3.0
eternalvs

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 更多

$140 USD 在2天内
(5条评论)
2.8
KISSMethods

A proposal has not yet been provided

$166 USD 在2天内
(1条评论)
3.0
IdeaCentre

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 更多

$60 USD 在3天内
(0条评论)
0.0
akhtar6035am

Sir I want to do this work I will complete it in time

$155 USD 在3天内
(0条评论)
0.0
jdp182004

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 更多

$155 USD 在10天内
(0条评论)
0.0
farazio2001

Dear I will complete your work in 3 days Check me Relevant Skills and Experience I am new

$155 USD 在3天内
(0条评论)
0.0
Geneed

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 更多

$30USD 在1天里
(0条评论)
0.0
tomcritter00

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

$138USD 在1天里
(0条评论)
0.0
gcriado

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.

$155 USD 在3天内
(0条评论)
0.0
jessicacardim

Eficiencia

$155 USD 在3天内
(0条评论)
0.0
probe2search

Hi, I have read through your job description.

$244 USD 在15天内
(0条评论)
0.0
cathtuti

A proposal has not yet been provided

$50 USD 在5天内
(0条评论)
0.0