Go Premium for a chance to win a PS4. Enter to Win

x
Solved

# Find 10 top values between two generic lists

Posted on 2015-01-08
Medium Priority
104 Views
I have two generic lists, with identical object T.
Code is like the primary key in the list.
List<T> listT1
List<T> listT2

T has the following fields
Code
Price
RetailPrice
SuggestedPrice

I need to find the top 10 codes which have the highest absolute Price difference between the two lists

Example
Code      list1   list2       difference
ABC        1000   2000   1000
LMN        500    50       450
0
Question by:countrymeister
1 Comment

LVL 75

Accepted Solution

käµfm³d   👽 earned 2000 total points
ID: 40538814
Here's one approach:

``````List<T> listT1 = new List<T>()
{
new T() { Code = "ABC", Price = 1000 },
new T() { Code = "LMN", Price = 500 },
};

List<T> listT2 = new List<T>()
{
new T() { Code = "ABC", Price = 2000 },
new T() { Code = "LMN", Price = 50 },
};

var query = from item1 in listT1
join item2 in listT2 on item1.Code equals item2.Code
select new
{
Code = item1.Code,
list1 = item1.Price,
list2 = item2.Price,
difference = Math.Abs(item1.Price - item2.Price),
};

var result = query.OrderByDescending(item => item.difference)
.Take(10);
``````
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
In real business world data are crucial and sometimes data are shared among different information systems. Hence, an agreeable file transfer protocol need to be established.
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
###### Suggested Courses
Course of the Month13 days, 10 hours left to enroll