Help: Need Linq Query to Filter on column

Help Studio
, ,
1

Hi All,

I need linq query for below scenario, Filter on Do no Column = 10923
and get all the filter data

Input:

Do no. Country
10923 India
10923 Russia
10923 US
78239 England
10923 India
78239 Russia

Expected Output:

Do no. Country
10923 India
10923 Russia
10923 US
10923 India

Also need another linq query to filter the data and store only data of country column into list

Country as list = {“India”,“Russia”,“US”,“India”}

Regards,
Vinit Mhatre

2

Hi @Vinit_Mhatre

You can use the below linq query for first scenario,

- Assign -> dt_Output = dt_Input.asenumearble().where(Function(X) X("Do no.").toString.equals("10923")).Copytodatatable()

use the below linq for second scenario,

- Assign -> LIst_Country = (From row in dt_Input
                            where row("Do no.").equals("10923")
                            Select row("Country")
                                ).Tolist()

Hope it helps!!

1 Like
3

Thanks for your help :slight_smile:

1 Like
4

It’s my pleasure… @Vinit_Mhatre

Happy Automation!!

5

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