Select a value from a data table referring to a specific value in another column

Help Something Else
1

Hi,

I have this Table:

image

I want to extract the value from the Detail Column where that Status=“Referral”

Can I use a LINQ query for this?
Thanks for helping.

2

HI,

How about the following?

arrResult = dt.AsEnumerable.Where(Function(r) r("Status").ToString="Referral").Select(Function(r) r("Detail").ToString).ToArray()

image
image1112×524 29 KB

Sample
Sample20240517-1.zip (9.6 KB)

Regards,

1 Like
3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.