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

I have 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:


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


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.

Taidot: Excel, VB.NET

Tietoa asiakkaasta:
( 298 arvostelua ) Charleston, United States

Projektin tunnus: #34264321

22 freelanceria on tarjonnut keskimäärin $23 tähän työhön

(194 arvostelua)

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

$35 USD 1 päivässä
(17 arvostelua)

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 anticip Lisää

$50 USD 2 päivässä
(138 arvostelua)
(24 arvostelua)
(8 arvostelua)

"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, ta Lisää

$20 USD 1 päivässä
(12 arvostelua)

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

$20 USD 1 päivässä
(6 arvostelua)
(1 arvostelu)
(3 arvostelua)

I have great deal of experience with VB.NET I develop very efficient implementations in terms of time complexity and performance. I have a bachelor's of Computer and Systems Engineering. I need more details, I think Lisää

$10 USD 2 päivässä
(1 arvostelu)

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 päivässä
(1 arvostelu)

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 päivässä
(1 arvostelu)

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 Lisää

$30 USD 7 päivässä
(0 arvostelua)

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

$15 USD 3 päivässä
(0 arvostelua)

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 päivässä
(0 arvostelua)

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 päivässä
(0 arvostelua)

.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 m Lisää

$20 USD 7 päivässä
(0 arvostelua)

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

$20 USD 7 päivässä
(0 arvostelua)
(0 arvostelua)

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 Lisää

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