Join two CSV files to a XLXS following rules
€8-30 EUR
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]
Nº du projet : #13775189
À propos du projet
40 freelances font une offre moyenne de 23 € pour ce travail
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.
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
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
I am an Excel expert and can join the files as per your instructions with 100% accuracy in few hours.
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
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.
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
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.
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
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.
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
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.
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
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.
sir pm me thanks ... sir pm me thanks ... sir pm me thanks ... sir pm me thanks ... sir pm me thanks ... sir pm me thanks ...
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.
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