LINQ to find a value in a column?

[Shiva_Nikhil]

@aquinn

can you replace the column Name with index and try or

can you share the excel so that i will check from my end

[aquinn]

Report.xlsx (333.7 KB)
Please see example using column A and P but this may change order

[Shiva_Nikhil]

@aquinn

its working can you check it

[ppr (Peter Preuss)]

As you can check

was accepted. Sometimes it helps to delete a valid statement which is not accepted and retype (typing not copy&paste) it again

[aquinn]

Can you please paste the LINQ in here so i can make sure it matches?

[Shiva_Nikhil]

@aquinn

dt1.AsEnumerable.ToDictionary(Function(x) x(0).ToString.Trim,Function(r) r(“Available Physical Stock - Today”).ToString.Trim)

replace the dt1 with your datatable variable

[aquinn]

@Shiva_Nikhil

dt1.AsEnumerable.ToDictionary(Function(x) x(0).ToString.Trim,Function(r) r(“Available Physical Stock - Today”).ToString.Trim)

I still get this

[Shiva_Nikhil]

@aquinn

please type the code dont copy and paste it

can you share the syntax which you have used

[aquinn]

Wow i typed it out manually and it works now… Thank you so much !