Data Lookup from Database

We need a system to be set up for us to generate the data as below;

- Three text files with different columns and about 14 mil rows can be downloaded from a website being updated every six month

- All files have a same column named Account#

- We make a new file with a column called Account# with the account numbers we are interested

- We need the data from other columns with similar account# to be extracted from the data source and be imported to our file.

- Should work on Mac systems.

- We have access to FileMaker Pro if necessary

Basically we need something like Vlookup function but having a large data source.

Taidot: tiedonsyöttö, Excel, FileMaker, PHP, tietojärjestelmäarkkitehtuuri

Näytä lisää: retrieve data marquee database, data entry database application, contact lookup database access 2007, what is lookup table in sql, what is lookup table in data warehouse, lookup table database design, what is lookup table in database, lookup table example, sql lookup table design, what is a lookup, database lookup table best practice, data entry, php, software architecture, excel, filemaker, save data xml database flash cs3, database russia phone numbers postcodes streets number buildings, ajax database search names numbers, send form data mysql database using php

Tietoa työnantajasta:
( 0 arvostelua ) United States

Projektin tunnus: #16213598

10 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hi there, I don't have experience of developing software for that. But if you are interested I can download whole database & convert to csv. I have experience of doing same work for Australia client who have high datab Lisää

$30 USD 3 päivässä
(219 arvostelua)

I am a FileMaker developer with 6 years experience and specializing in filemaker support and outsource services I can deliver you the best results when it comes to FileMaker Projects..

$40 USD 1 päivässä
(16 arvostelua)

Hello, I thin a shell script will fit your needs. Can write it in Bash, which works on Mac. Thank you.

$30 USD 1 päivässä
(68 arvostelua)

Hello If I understand your project description correctly, you are looking to extract data, matched by Account#, from the 3 text files and imported into your solution? As you have access to Filemaker Pro, I recommen Lisää

$280 USD 5 päivässä
(13 arvostelua)

Hi, The best way to tackle this problem is to use a command line script to do the "vlookup" part for you. So the idea would be to export the large dataset as a CSV file (I expect you would probably receive that Lisää

$35 USD 0 päivässä
(12 arvostelua)

we have an experience team who love to work with you. please come on chat so we can discuss more about the project.

$17 USD 1 päivässä
(0 arvostelua)
$13 USD 1 päivässä
(0 arvostelua)

A proposal has not yet been provided

$25 USD 1 päivässä
(0 arvostelua)

Use match-index function combo... it is much robust and user friendly

$10 USD 1 päivässä
(0 arvostelua)

14 mil rows can be quite a difficult for Excel to handle. Besides, you probably want to keep history (for more than just 6 months). The fastest software to use - BI system. Qlikview Personal edition is free but has som Lisää

$100 USD 5 päivässä
(0 arvostelua)