Need some VB.NET code that will look up values in one array based upon values in another array

$10-30 USD

已关闭

已发布

超过 1 年前

$10-30 USD

货到付款

I have VB.net code that creates a Dictionary. The information can be converted into a multidimensional array, with PMID, ISSN and YEAR. Every Article is Published with a unique ID in a Journal that has an industry assigned unique ID in a particular YEAR. So, my data can look like: PMID ISSN YEAR 29374060 0007-9235 2022 29618665 1471-0072 2022 29662628 1740-1526 2022 29735528 0007-9235 2021 29748384 0007-9235 2022 29844859 0140-6736 2022 29871931 0007-9235 2022 29876004 0140-6736 2021 29983887 0028-4793 2022 29996914 0140-6736 2021 29996940 1474-1776 2021 The PMID is unique but the ISSN and YEAR can and will be duplicates. They could be 1000 rows. I need to add values to the array that are stored in another table. The structure of the other data is open to discussion, but both are provided in smaller samples. I need the most efficient application because this table could have 10,000 rows. Structure A: Could have each Year as a separate Row or Structure B could have each Year and values as separate columns, but I could have 20 years of data. Structure C could have each Year as a separate data file. The majority of the data will come from 2018 up to the current year. So I might be able to manage total row object to 10,000 or less. Open to suggestions and a working proof of concept. Excel Spreadsheets have been provided with data. Hopefully your option is a little more efficient then looping the data table for each element in the object table. ISSN ESSN YEAR Full Journal Title Impact Factor 0007-9235 1542-4863 2022 CA-A CANCER JOURNAL FOR CLINICIANS 508.702 1471-0072 1471-0080 2022 NATURE REVIEWS MOLECULAR CELL BIOLOGY 94.444 0028-4793 1533-4406 2022 NEW ENGLAND JOURNAL OF MEDICINE 91.245 1474-1776 1474-1784 2022 NATURE REVIEWS DRUG DISCOVERY 84.694 0140-6736 1474-547X 2022 LANCET 79.321 0007-9235 1542-4863 2021 CA-A CANCER JOURNAL FOR CLINICIANS 308 1471-0072 1471-0080 2021 NATURE REVIEWS MOLECULAR CELL BIOLOGY 35 0028-4793 1533-4406 2021 NEW ENGLAND JOURNAL OF MEDICINE 31 1474-1776 1474-1784 2021 NATURE REVIEWS DRUG DISCOVERY 34 0140-6736 1474-547X 2021 LANCET 39 The uniqueness is based upon the ISSN and the YEAR. Please do not low ball bid then ask what's my budget. If I chat with you my budget is your bid.

Excel

VB.NET

项目 ID: 34264321

关于此项目

20提案

远程项目

活跃2 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

20威客以平均价$24 USD来参与此工作竞价

@WebInfoSolutions

Just need another table structure and at what level will it be added in array as child. Lets start the project

$35 USD 在1天之内

5.0

(17条评论)

5.8

@merinsinha

Excel, vb. Net expert. I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platfrom give me a chance to show you the best i can do at your service.

$50 USD 在2天之内

4.8

(149条评论)

5.8

@Maherun75

"Dear Client, I specialize in Word or Excel VBA / Macro solutions and Web Scraping/Data Mining for your Excel workbooks. I will perform any tasks in Excel to automate your business. VBA macros, custom forms, charts, tables, absolutely any request will be satisfied. If necessary, I will write accompanying documentation or video. Ready to solve a problem of any level of complexity. Services Offered: ✅Automating Tasks. ✅Data Validation. ✅Data Analysis. ✅Custom Formulas. ✅Creating User Forms. ✅Charts. ✅Pivot Tables. ✅Formatting, Fixing, Forms, Formulas, Functions. ✅VBA Macros Automation. ✅Web Scraping/Data Mining from any website and any amount of data. ✅Data collection, Images Downloadable / Images URL. At any time ready to provide support on emerging issues. I am happy to provide after-sales support, you can always count on me. ""✌️People like surprises and here I come into play, to present your ideas to the world in the best manner✌️"". Please don't waste your time looking around. Please feel free to contact me. I'm ready to start your project. Thanks in advance!"

$20 USD 在1天之内

4.5

(18条评论)

4.4

@NANSAMEERA86

Hi Sir, I am Sameera from Sri Lanka and I have more than 10 years working experience in report automation using excel vba and macros so this can be done .I am waiting your reply. thanks Sameera.

$10 USD 在1天之内

5.0

(29条评论)

4.1

@freddyho

Hello, I am really capable for creating this program. And do not mind submitting the vb.net code as well with the submitted program. My price is really fixed, will not negotiate additional fee. Thank you.

$20 USD 在1天之内

4.8

(10条评论)

4.3

@dasmandira517

.hi, I can able to this job & I am very much interested in working on your project. I have a good experience of the work. I can for this task with 100% accuracy. If you need any sample please let me know. we discuss more and when we need to start? I am a quick, reliable, and efficient worker. I am available to start work immediately. regards, Mandira

$20 USD 在7天之内

4.9

(3条评论)

1.4

@freelancepraful

I can work on lowest bid for vb coding , please check my reviews ratings and completed projects. I am available now, please connect with me.

$10 USD 在3天之内

5.0

(1条评论)

0.6

@topgradeclubltd

Hi, Greetings and hoping you are doing well, i welcome you to my profile where quality and client satisfaction is the Priority. I am Expert DOMINIC and i hope to cooperate with you on your project. CERTIFIED EXPERT IN LISTED PROJECT SKILLS & REQUIREMENTS, After KEENLY reading your description and being in possession of all CLEARLY STATED REQUIRED SKILLS (Excel and VB.NET) as this is my area of PROFESSIONAL SPECIALISATION having the above QUALIFICATIONS, i hereby humbly request you to consider my bid for QUALITY and PROFESSIONAL work. ###// No timeline & Quality Excuses// Unlimited Revisions// 100% SATISFACTION GUARANTEED### Message Me We Discuss More About The Project. incase the project is deleted please hire me directly using the following link; https://www.freelancer.com/u/topgradeclubltd THANK-YOU & WELCOME.

$30 USD 在7天之内

0.0

(1条评论)

0.0

@yadavharikrisan8

Hello My Name is Vishal Kumar Yadav. You Give your project i complete a soon as much as possible. Thank you

$15 USD 在3天之内

0.0

(0条评论)

0.0

@minuk9811

I am a professional data entry expect. I have great speed and I do work without any mistakes. I can complete the work.

$10 USD 在3天之内

0.0

(0条评论)

0.0

@ShRNWaZ

helo there! I read the above conditions and I need the sample data and more celebration to assist you with this. I will do my best to structure it the way you wish. do message if you think I can help.

$20 USD 在7天之内

0.0

(0条评论)

0.0

@JoaoCouceloDev

hi i work with vb.net for 3 year im a software developer and definitely can help with this task, hope to hear from you. best regards

$20 USD 在7天之内

0.0

(0条评论)

0.0

@Hassan301991

Hi client, Hope you are doing well, I am happy to see your project. I have a lot of offline experience. But I have experience of 10 years an office assistant. And I complete Diploma in Graphic Designing and Diploma in Computer science also. So I can do this work.

$10 USD 在1天之内

0.0

(0条评论)

0.0

@KevinDataExpert

Hi, I am a business analyst and I normally deal with datasets as large as 2-3 million rows. I understand the best way to approach your issue. It can even be done without VBA as it seems you have some flexibility with your second data table. I believe the below is the output you are looking for. This was done without VBA, and it will run in seconds even if your first table has 1,000 rows and your second table has 10,000 rows. If this is the output you are looking for, please accept my bid and I will be able to complete this for you within 3 days of receiving your source data. Thank you, Kevin PMID ISSN YEAR Impact Factor 29374060 0007-9235 2022 508.702 29618665 1471-0072 2022 94.444 29662628 1740-1526 2022 Not found 29735528 0007-9235 2021 308 29748384 0007-9235 2022 508.702 29844859 0140-6736 2022 79.321 29871931 0007-9235 2022 508.702 29876004 0140-6736 2021 39 29983887 0028-4793 2022 91.245 29996914 0140-6736 2021 39 29996940 1474-1776 2021 34

$20 USD 在7天之内