Create a [url removed, login to view] file uniting the following files.
FILES TO UNITE:
01 - TALLO - [url removed, login to view]
02 - MASNOU - [url removed, login to view]
03 - OPENFOOD - [url removed, login to view]
04 - AECOC - [url removed, login to view]
05 - CODROPER - [url removed, login to view]
06 - MERCADONA - [url removed, login to view]
07 - PHARMA - [url removed, login to view]
08 - CONDIS - [url removed, login to view]
09 - CARREFOUR - [url removed, login to view]
10 - DESPENSA - [url removed, login to view]
11 - ALCAMPO - [url removed, login to view]
12 - VINATERIA - [url removed, login to view]
Download from: [url removed, login to view] (.zip file / 16Mb)
When creating the [url removed, login to view] follow this importing order.
- First, import file 01 - TALLO - [url removed, login to view]
- Second, import file 02 - MASNOU - [url removed, login to view]
- Thirdm import file 03 - OPENFOOD - [url removed, login to view]
- Last, import file 12 - VINATERIA - [url removed, login to view]
The files should be united by EAN
The EAN will be like and UNIQUE ID.
An EAN will appear only in one row --> NO repeated EANS in different rows.
HOW TO PROCEED: (VERY IMPORTANT)
Before importing the row you have to check if the EAN exists in [url removed, login to view]
- If EAN do not exist --> Create the NEW row with the values of the columns.
- If EAN exist --> Update Values OVERWRITE EXISTING values. (We substitute old values for new ones if there is text in the cell)
If the value of the cell is NILL OR NULL OR "" OR VOID or FALSE --> We do not update that specific value, we do NOT OVERWRITE
All files have these columns.
EAN Column: All of them have a value.
Rest of columns: some have values, some not.
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Plus
13 freelance font une offre moyenne de €27 pour ce travail
Hi, Ready to start. I can create custom scripts to join CSVs as required. Could you please send the link again? It is disabled. I am detail oriented and I strive to maintain accuracy and high quality in my work. Loo Plus
Hi There, I have read project details carefully and I will add in [login to view URL] file from all 12 .csv files according to provided description, kindly message me so I will be able to complete sample to show you or I am rea Plus
Hello. I'm a programmer, I create custom programs for any purpose. I will create a program which will read the input files and create the new files according to the specifications you want. I will do with working with Plus
hello sir i understand what needs to be done ,,,, i can do this work in 2-3 hours from now i am an expert in excel and have completed many excel projects in past with excellent ratings so please msg me to d Plus
I can merge all your CSV files in couple of hours and I can offer you best price here. You have pretty good project description so all I need to start is milestone payment from you. You'll release it only after you Plus
EXPERIENCED WITH THIS PROJECT. I am Certified Professional at award winning digital marketing startup company in the Philippines called ROC.PH. I am available and can start immediately.
Hello I am Asaduzzaman Apu I see your project and i do it as your acceptation.I have 3 years experience to work in a any kind data process Web Scraping, Web Search, Excel,Affiliate Marketing, Email Marketing, Internet Plus
Greetings! My Name is Ram dadhich and 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 y Plus
I would like to work on your project. I believe I can complete in a few hours, depending on the number of rows in each file. I would just have to prepare a script to run through each row for each file, to determine t Plus
Hello sir/madam I've read your ad about managing CSV in excel. I have checked your data. I can work for you and deliver you in some hours or more. Hope you hire me!
I did excel works befor...and as per rules... and the major thik is I am 24/7 active.. so buyer can communities with me any time
Hi Client, Good Day! I am Mykell Lirio. I think I can help you with this project as I know how to consolidate your CSV files. Here's what I'm going to do: 1. Import your files sequentially as stated in your job Plus