SQL and Excel data cleaning expert

Folyamatban Kiadva: 6 évvel ezelőtt Kiszállításkor fizetve
Folyamatban Kiszállításkor fizetve

Aim: Create Excel Control worksheets that runs Macro to perform the following:

1 Extract two data file(.xls) from known location and remove unused column + N/A (300K rows) The file is very large and therefore need to be efficient and effective.

2. Export data to SQL (create 2 new table- [url removed, login to view], xx2 )

3. Join/ map the two SQL table to a "product list" (if the mapping doesnt exist- create error message and a log of what is missing)

4. SQL to group/ sum criteria (this will be indicated in the "control worksheet")

5. Export the data out in Excel table and saved in indicated location

Excel MySQL SQL Visual Basic

Projektazonosító: #16113280

A projektről

6 ajánlat Távolról teljesíthető projekt Utoljára aktív: 6 évvel ezelőtt

6 szabadúszó tett átlagosan 144$ összegű árajánlatot erre a munkára

polarjin2017

Hello? How are you? I have good skills in excel and vba, vb. So i can help you then. i will never disappoint you. Hope to see you . Thanks.

$155 AUD 3 napon belül
(46 vélemény)
5.8
awaisjahangir25

Hi, I’ve good working experience of MS Excel and VBA programming. I’ve done several project relating this and you can review my profile as well. Kindly text me if you are interested in working with me. Thanks

$100 AUD 1 napon belül
(28 vélemény)
5.1