Merge text files using field matching
$30-250 USD
S-au achitat serviciile după ce au fost prestate
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.
ID Proiect: #18066978
Detalii despre proiect
Acordat lui:
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.
Hello I'm experienced developer of Windows applications. I'm strong in Python, SQL and data analysis. Apart of that I can create the native executable program using one of the compiled languages - Golang or Delphi. Mai multe
17 freelanceri plasează o ofertă medie de 158$ pentru proiect
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 Mai multe
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 Mai multe
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 Mai multe
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.