Færdiggjort

Merge text files using field matching

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.

Evner: .NET, Microsoft SQL Server, Python, SQL

Se mere: merge text files together using, merge text files using vbnet, merge text files, combine text files using excel macro, merge text files column, processing text files using vbscript, vba merge text files file, merge text files together vba, merge text files file program, vbs script merge text files, merge text files using vb6, merge text files using, merge text files using vbs, merge text files based common field, combine merge text files using, merge text files using keys, merge multiple text files using vb6

Om arbejdsgiveren:
( 73 bedømmelser ) Harrogate, United Kingdom

Projekt ID: #18066978

Tildelt til:

prakash2813

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.

$180 USD in 2 dage
(12 bedømmelser)
4.8
exansoft

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. Flere

$200 USD in 3 dage
(18 bedømmelser)
5.7

22 freelancere byder i gennemsnit $152 på dette job

expertcoder1vw

Hi, I'm an EXPERT database developer, and can deliver this solution to you as a Windows console application (EXE) developed using C++, that you can run from the console or scheduler etc. MERGE [login to view URL] [login to view URL] [login to view URL] Flere

$150 USD in 3 dage
(32 bedømmelser)
5.5
Mickelson

Hi Nice to meet you. I'm python expert and my last project on freelancer.com is also python scraping task. My past works: Youtube comment scrapping Realestate property list to csv Jobsite content to csv And scra Flere

$125 USD in 3 dage
(27 bedømmelser)
5.6
wang1013

Hello. I am very glad to meet your job since I have sufficient experience in Python and text analyzing with Python. And I have lots of skills in NLP and text parsing, so could help you perfectly. Please contact me a Flere

$170 USD in 3 dage
(26 bedømmelser)
5.6
oyasniy

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

$155 USD in 3 dage
(12 bedømmelser)
5.1
dobreiiita

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 Flere

$200 USD in 3 dage
(53 bedømmelser)
5.4
contactsapphire

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 Flere

$155 USD in 3 dage
(9 bedømmelser)
5.9
qunzhuang323

Hi I have read your project description very carefully so I am confidence to complete your project I have finished lots of such projects successfully. I am an experienced and skillful programmer. I have full expe Flere

$32 USD in 2 dage
(13 bedømmelser)
4.2
ganeshrasekar

I can do it............................................................................................................................................................................................................... Flere

$155 USD in 3 dage
(8 bedømmelser)
3.6
wonwon424

Hi, employer. I've read your requirements and I think I can do it. I think your program should be built by python or java. And I think we should use cron job for running. I have many previous works in this field an Flere

$166 USD in 3 dage
(7 bedømmelser)
3.7
nataliaomelchenk

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.

$155 USD in 3 dage
(2 bedømmelser)
3.0
BubbleJet23

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 Flere

$100 USD in 3 dage
(1 bedømmelse)
3.3
$222 USD in 7 dage
(1 bedømmelse)
2.4
mumarsami

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

$222 USD in 3 dage
(4 bedømmelser)
2.3
sachchusinghal

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

$277 USD in 3 dage
(4 bedømmelser)
1.4
chali5

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

$150 USD på 1 dag
(1 bedømmelse)
1.5
reshab48

Hello sir, My name is reshab, i am a python/django backend developer with over 3 years of experience in developing apps, scripts, etc. For your project, i will create a python script that will be used as a cron job Flere

$120 USD in 3 dage
(2 bedømmelser)
1.2
nguyenvanha1991

good java + Python + banking system. good java + Python + banking system. good java + Python + banking system. good java + Python + banking system.

$45 USD in 3 dage
(1 bedømmelse)
0.4
Marsson87

In my daily work I am using different sources of data and post-process it in various ways. I am familiar with SQL databases and Python as well. In my opinion Python script for such task is the best choice. From my side Flere

$166 USD in 2 dage
(0 bedømmelser)
0.0
endlichfelipe

As a computer scientist I've done several projects like that in university. If you want to know more information contact me

$30 USD in 2 dage
(0 bedømmelser)
0.0
roelofsleroux

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.

$166 USD in 5 dage
(0 bedømmelser)
0.0