Combine data and match it against other data -- 4
$30-250 USD
Pagado a la entrega
We would provide the following:
FTP with a folder with:
About 165 csv files with apprx. 260,000 lines each and 9 columns. There are unique identifiers in Column A and information about these unique identifiers in the following columns. Each csv file’s name is a timestamp showing the exact date of the information in the file.
One additional xlsb file with unique identifiers in Column A, Date in Column B and additional information for the unique identifier in the following columns.
We need the following to be performed:
All csv files to be combined into one database, keeping the date of each unique identifier.
All unique identifiers with their dates in the xlsb file to be matched against the same unique identifiers from the same date in the csv files.
Once matched, the data from column B to I from the csv files to be pasted in the xlsb files on the unique identifier’s line from column E to column L.
Example:
The xlsb file contains in Column A, unique identifier 123456, in column B, on the same line is date 01/08/2016
We would need to find the unique identifier 123456 in the csv file from 01/08/2016 and then copy the information from column B to I on the same line as the unique identifier, and then paste it in the xlsb file, on the same line as the unique identifier in the same order, starting from column E.
Then, we would need the xlsb file with all of the above information and one file with the combined csv files.
The database with all of the combined files would not necessarily contain all of the fields in each of the csv files but to the very first csv file should be added all the changes in the information concerning each unique identifiers. If no change has occurred, the unique identifier's information doesn't need to be duplicated.
In order to get a better understanding of the scope of the job- the xlsb file contains about 40,000 lines.
We have about 165 csv file. Each of the csv files contains about 240,000 lines.
At the end, we will need the files and a guide how to perform this operation ourselves in the future.
Nº del proyecto: #11352309
Sobre el proyecto
17 freelancers están ofertando un promedio de $169 por este trabajo
please write more details ...........................................................................
Hi, please provide more details regarding your project. regards, Narek.===========================================
Hi there, I am java developer. Can you send me sample csv and xlsb file? Message me, we can discuss over chat.
Hello, I will help you on this. Can you share the sample file with some sample records for better understanding. I can deliver windows app to make this. Thanks, Sheik
Hi. I am a MySQL expert and have high experiences about it. I hope a long term relationship with you. I am ready for you. Don't award me before discussion. Contact me. Best regards. Thx.
Vba expert, can write macros that can accomplish this. Macros will allow user to specify directories etc to search. All my code is extensively documented for re-use
Dear Sir, Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have checked your requir Más
Hi, Have gone through the requirements. Have good experience in writing custom scripts as per the requirements. We will have a web interface may be you can run in local or online to perform all this process th Más
I often use mysql or postgresql to handle large amount of csv data. And I can use python connecting SQL for further select\insert management. Recently I am dealing with a mobile user Location data with 6,000,000 lines.
Hi, I can do this job. I can write a PERL program to combine all CSV files and match with the xlsb file. You can run the PERL program in both Windows and UNIX/LINUX. Please tell me your FTP access. Thanks.