Merge text files using field matching

Færdiggjort Opslået 5 år siden Betalt ved levering
Færdiggjort Betalt ved levering

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.

.NET Microsoft SQL Server Python SQL

Projekt ID: #18066978

Om projektet

17 bud Remote projekt Aktiv 5 år siden

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
(15 bedømmelser)
5.0
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
(24 bedømmelser)
5.8

17 freelancere byder i gennemsnit $158 timen for dette job

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
(15 bedømmelser)
5.6
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
(56 bedømmelser)
5.5
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
(12 bedømmelser)
5.9
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
(6 bedømmelser)
4.2
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
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
(8 bedømmelser)
3.0
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
(7 bedømmelser)
3.3
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
(2 bedømmelser)
0.4
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
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
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