Merge text files using field matching
$30-250 USD
Pagado a la entrega
We have a couple of instances where we want to extract a particular view in a MS SQL Server data base (lets call this A) with older, similar data in a text file from a legacy system (B). The output should be in text file - csv (C).
The goal is produce a single file C we can do analysis on.
The starting point is always A - all the rows and all the fields.
We then want to add all the rows in B, matching up the field according to a table.
Example:
A
Account Invoice Product
A0001 1233 abc
B
Customer Invoice Stock Code
B002 2344 GHJ
using the field mappings we define, either tin the code or another file
A field B field
Account = Customer
Invoice = Invoice
Product = Stock Code
This would give as output C:
Account Invoice Product
A0001 1233 ab
B002 2344 GHJ
There will never be more fields in B than A buthere could be less (use blank or null if so).
I think we'd prefer python but dont really mind.
The field mappings and the input and output files should be edittable, but this can be in the code.
We want to run the program in batch mode, no GUI etc needed - just something we can schedule to run over night.
We have data now.
Nº del proyecto: #18066978
Sobre el proyecto
Adjudicado a:
Hi there, I am java developer. I have read the details and looks an easy job for me. I can write a console app to this job easily. Message me, I would like to discuss further over chat.
17 freelancers están ofertando un promedio de $158 por este trabajo
Hi, I would like to merge the files using the field matching for you. You can rely on me. I am an experienced developer. Looking forward to hear from you. Best regards, Oleg
Hello I am Java based development expert and interested in this project. I have reviewed the details of the project and confident to handle it perfectly. I will keep codes simple and well documented. Please comm Más
Hi! I have reviewed the requirements for mapping 2 different tables and getting the output in a single result set. We will allocate a 4+ years experienced .NET/SQL developer. We will be available during your offi Más
Hi, there. Nice to see you. Thanks for your clear spec. I will finish your task in 4 hrs perfectly. No problem. I read all carefully and feel good. Please send me the files. I will do my best. Thank you.
Hi there, I’ve read your requirement to merge data in SQL to a older legacy system and I can do this for you. I have been working as an analyst programmer for almost 10 years and have done a lot of similar things pre Más
Hello, I am expert in Python and would love to discuss the queries if there is any during the understanding. Are you available on chat. Thanks, Sachin
I am an expert DBA with more than 10 years of experience. I will be to resolve your project as per your requirement. Please feel free to discuss. Regards
Hi I am a software engineer i have read the details of your project and i can do in less time with quality so please contact me thanks
good java + Python + banking system. good java + Python + banking system. good java + Python + banking system. good java + Python + banking system.
As a computer scientist I've done several projects like that in university. If you want to know more information contact me
Can easily build a script that can be run on schedule to perform this function. Thinking of PowerShell as the base tech for this project.