Đã hoàn thành

Merge / Update CSV Files

Merge the content of the files File_1, File_2 and File_3

The resulting file will be a csv file.

(During the merging process you can use any format you want)

Rules of merging:

File_1:

File_1 is the base file

File_1 content will be updated and added.

If the row exist → Update values of the existing fields

If the row do not exist → Create row

Add File_2 to File_1: Resulting in temp flie File_12

The resulting file (File_12) have the content of File_2 in the case the content exist in both files, File_1 and File_2.

Use the field MERCADONA_ID in order to link one file with the other.

Rules:

- IF MERCADONA_ID exists in File_1 → Update Values (Do not delete values of File_1 that do not exist in File_2)

- IF MERCADONA_ID do not exist in File_1 → Add Rows to File_12 with new values of File_2

Add File_3 to File_12: Resulting in temp flie File_123

IMPORTANT to do this process to file File_12 (the resulting result of merging File_2 to File_1. Not directly to original File_1)

The resulting file (File_123) have the content of File_3 in the case the content exist in both files, File_3 and File_12.

Use the field MERCADONA_ID in order to link one file with the other.

- IF MERCADONA_ID exists in File_12 → Update Values (Do not delete values in File_12 that do not exist in File_3)

- IF MERCADONA_ID do not exist in File_12 → Add Rows to File 123 with new values of File_3

This final file File_123 is the one I need.

Download files from:

File_1: [login to view URL]

File_2: [login to view URL]

File_3: [login to view URL]

Kĩ năng: Data Cleansing, Xử lí dữ liệu, Excel

Xem nhiều hơn: update csv using mysql, vbscript parse csv files, plotting csv files excel, merge csv files without header, csv merge tool, how to merge excel files into one using cmd, merge csv files mac, merge csv files python, merge csv files linux, merge csv files online, merge xlsx files command line, data entry, data processing, excel, google base csv files, format csv files need upload outlook, using csv files update inventory, need multiple create csv files csv file, use script file edit csv files, automatically update database csv files

Về Bên Thuê:
( 20 nhận xét ) Barcelona, Spain

ID dự án: #17253418

Được trao cho:

REDFEATHERART

Hi, I have read the description. I have 9 years of experience doing such kind of work. I am an expert. Thanks

€25 EUR trong 0 ngày
(2 Đánh Giá)
1.6

30 freelancer đang chào giá trung bình €37 cho công việc này

schoudhary1553

Hi there..... Warm Greetings We came along with your request for Merge / Update CSV Files and we reviewed your project description. We'd like to help you with confidence and satisfying results... We have p Thêm

€90 EUR trong 2 ngày
(256 Nhận xét)
7.5
KulfiSoftwares

Excel expert.. I can merge, remove duplicates and update the file with zero errors. ZERO ERROR GUARANTEED!! Please read my 350+ reviews. I am here to impress you with my work.

€50 EUR trong 1 ngày
(248 Nhận xét)
7.4
khushh07

Hi, I understand your requirement and can do the job well. I have experience of more than 300 project in different categories and we have started a new new team of web developers. I look forward working with you and Thêm

€55 EUR trong 1 ngày
(262 Nhận xét)
7.1
priteshkhande88

I am a skilled freelancer who has a working experience of more then 7 year I have working experience on- Web Research, lead generation, data entry, data mining, lead collection, All types of scrapping tools like - da Thêm

€8 EUR trong 1 ngày
(38 Nhận xét)
5.4
satishtl

- Went throught the files [login to view URL] [login to view URL] [login to view URL] - Comparing the files based on MERCADONA_ID and addiing or updating rows in File_1 from File_2 resultatnt file File_12 To this fhis file compare File Thêm

€102 EUR trong 2 ngày
(45 Nhận xét)
5.9
dvcontact

Hi, You won’t select the right candidate without knowing what your project on merging and updating CSV files will look like. Fortunately, I can complete a part of your job before you award the project. I am confide Thêm

€30 EUR trong 1 ngày
(31 Nhận xét)
5.3
€8 EUR trong 1 ngày
(27 Nhận xét)
5.0
archanaoswal

I have excellent command on MS Excel. I have completed complex projects in Excel before . For instance - Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (AP Thêm

€50 EUR trong 1 ngày
(44 Nhận xét)
5.2
ESOLUTIONSSS

Hello Sir/Madam, It is my pleasure to be able to bid on your project. Really very much interested to have this project, if you permit. I am 100% confident that I can execute the project with good quality that Thêm

€23 EUR trong 1 ngày
(33 Nhận xét)
4.6
josefN

Hello, I can do this for you. I would write a script for this. This way I can fix bugs and run it over over again. It should be quick job Josef

€30 EUR trong 1 ngày
(17 Nhận xét)
4.3
Stephenrajs

Hi there, I can do it. I have done many related projects like this. If you are provide this work, it will help my career also. Give me a chance to do this. Waiting for your precious reply. Thank you.

€20 EUR trong 1 ngày
(25 Nhận xét)
3.6
DataExpert3

I read through the description extremely carefully and I am absolutely sure that I can do the project very well. I have broad experience on projects like these, you can check my profile to read my clients reviews ! Thêm

€34 EUR trong 3 ngày
(7 Nhận xét)
2.6
iwebphpdeveloper

Hello Dear, I checked your given requirement details and as you want merge the content of fthe ile 1, file 2 and file 3.I am ready to work for you as per your requirement. I have a team of designers and content wri Thêm

€30 EUR trong 1 ngày
(2 Nhận xét)
2.6
RAZAQ786

hi,sir/madam I am providing All types of Online and Offline Data Entry, Web Research Jobs. Whether you need an enthusiastic Virtual Assistant or Office Admin Support I'm very willing to work with you. I'm fully capabl Thêm

€23 EUR trong 1 ngày
(1 Nhận xét)
2.4
freelancer596

I can able to do this and start the work immediately. I have done a lot of work related to this. Kindly contact me for more discussion,

€30 EUR trong 1 ngày
(1 Nhận xét)
2.3
superlopes

Hi, I have 6 years of experience with software development, mostly with java and web frameworks. For your project I will create a simple python script to do the merge. Please let me know when do you it read Thêm

€24 EUR trong 1 ngày
(1 Nhận xét)
2.1
dataexplorer

Hi Dear, I am efficient web researcher and quick data entry professional. I am familiar with MS Excel and Google Docs spreadsheet. i can do your Update CSV Files project. I’m able to Research products, Entering prod Thêm

€30 EUR trong 3 ngày
(3 Nhận xét)
1.6
€10 EUR trong 1 ngày
(2 Nhận xét)
1.7
bappyhasan352

Dear Sir, This is Zahid, I read your job description "Merge / Update CSV Files" very carefully. I have depth knowledge of this type of jobs. Because I have already 2 years’ experience in another marketplace. I have ma Thêm

€50 EUR trong 1 ngày
(0 Nhận xét)
0.0
€15 EUR trong 1 ngày
(0 Nhận xét)
0.0