Join two CSV files to a XLXS following rules

Annulé Publié le il y a 6 ans Paiement à la livraison
Annulé Paiement à la livraison

Import first the file "01 - VINATERIA - [login to view URL]" second import the file "02 - CARREFOUR - [login to view URL]" to destination file "[login to view URL]"

Importing Rules:

EAN: it is a string and it is the key field.

ROWS are imported following the rule:

If EAN do not exist in FINAL --> Add the new row to FINAL

If EAN exist in FINAL --> Modify only the values that do not exist in final

Output:

The project is generate the updated file [login to view URL]

Please, be carefull with EAN. EAN must be a string, not a number (not things like 2^14)

Please, check example of importing rules:

[login to view URL]

Please, use this files:

01 - VINATERIA - [login to view URL] - 377Kb

02 - CARREFOUR - [login to view URL] - 13.018Kb

[login to view URL] - 27.349Kb

Download from: [login to view URL]

Saisie de Données Traitement de Données Excel

Nº du projet : #13775189

À propos du projet

40 propositions Projet à distance Actif il y a 6 ans

40 freelances font une offre moyenne de 23 € pour ce travail

FINGERRPRINT

we have gone through your project description. we have more experience in csv file and importing files. we can get you final xlxs file as you want.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(355 Commentaires)
8.2
TonmoyRoy111

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me for further detail Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(433 Commentaires)
7.1
ReliableMate

Will do this one for a good review! Professional work, in time, with ZERO errors, for sure! We can do this for you quickly and with great quality as per your budget.. We aim to be your one stop solution for ALL Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(149 Commentaires)
6.7
best4best

I am an Excel expert and can join the files as per your instructions with 100% accuracy in few hours.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(209 Commentaires)
6.6
The24CarrotsInc

A proposal has not yet been provided

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(56 Commentaires)
5.7
nagybatonyi

Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macr Plus

€20 EUR en 0 jours
(64 Commentaires)
5.7
NEEMISH

Hello Sir, I have completed the job please award me the job so that I can send the file. Please send me a message here.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(58 Commentaires)
5.6
rinsadsl

Hi there I can merge the 2 files into a new file using EAN as the key to add or update. Looking forward to hear from you. Thanks Rinsad

€33 EUR en 2 jours
(46 Commentaires)
5.8
sergpooh

Hello. I have an experience with C# and VBA and I can make a good solution for you. I made a similar program in the past. I always make a good job as you can see at reviews.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(42 Commentaires)
5.5
rakshitdadhich

Greetings! I am an expert in Microsoft excel/ Data entry. I would love to have the opportunity to discuss your project with you. I feel I am best fit to complete your project. I have 10 years of experience of parti Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(23 Commentaires)
5.0
surekash7096

I have the expertise in Excel and can do this task, as per requirements, quickly and accurately. I have experience doing the merge of csv. Ready to start work immediately.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(67 Commentaires)
5.4
prabakarm23

I have 7 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 Server databases. And also I Plus

€50 EUR en 3 jours
(50 Commentaires)
4.7
wiisetech

Hi, I am interested in this job. I understand what you required. I will provide you fast,quality and error free work because I am professional and experienced in it. Waiting to discuss with you more. Regards.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(42 Commentaires)
4.2
iqmax99

Hello I would like to work with you on your project. I have 20 years of software development and can start now. I understand the requirements. I see that you have a "bug" in the example you posted on the given URL. Plus

€44 EUR en 3 jours
(15 Commentaires)
3.7
cheungkc

Hi, I have reviewed the sample files. The 2 csv files are semicolon delimited, so we must use Data/import/text file. When doing so, we have the option to specify EAN is text field. I note in the final xlsx file Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(6 Commentaires)
3.1
Sunil986020

I am Expert in MS Excel with Advance VBA programing, I can complete your project within 2 - 3hour I complete your project within your budget. Lets complete your project.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(2 Commentaires)
2.6
glennwilkins

sir pm me thanks ... sir pm me thanks ... sir pm me thanks ... sir pm me thanks ... sir pm me thanks ... sir pm me thanks ...

€30 EUR en 0 jours
(5 Commentaires)
3.2
roman239

Hello, I can use Python to merge those files and I have already written such script. I can send you first 1000 records like prove. Best regards, Roman.

€12 EUR en 0 jours
(4 Commentaires)
2.2
Tariqsb

Sir, I have great experience of work. i have experience in Excel, Typing, pdf to Word, Adobe Photoshop,Web Searching, JPEG to word and Excel and all type of office work. I know the value of time. Sir, i thinks so t Plus

€29 EUR en 15 jours
(3 Commentaires)
1.9
ghastlyspecter

Dear Client After reading your post's job description, I hastily bid as it match my acquired knowledge and skills. With my extensive experience in Excel I am confident that I am able to accomplish the task immediate Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(2 Commentaires)
1.8