Linq in uipath for filtering of numeric value

Help
1

Hi all i am facing the issue win filtering of query using linq every time its coming AsInumerable () error. Even i have chaged xmal file too but the issue is not resolve

1 Like
2

Hi @akv,

Welcome to the community :slight_smile:

Can you share the LINQ query you are using for reference

1 Like
3

Hi
Welcome to uipath community
kindly share your LINQ query if possible
are we trying to convert any datatype in that LINQ query

Cheers @akv

4

i will share you my screen shot

5

sure
Cheers @akv

6

Is the query solved ?
If not do mark the post as unsolved :expressionless:

7

Screenshot%20(29)
Screenshot%20(29)1920×1080 187 KB

1 Like
8

nope

Screenshot%20(32)
Screenshot%20(32)1920×1080 191 KB

9

may i know what is mentioned in the right side of that assign activity
kindly share that expression
Cheers @akv

10

dt1.AsEnumerable.Where(Function(row) row(“NAME”).ToString.Trim=“1”).CopyToDataTable()

11

you were almost done
dt1.AsEnumerable.select(Function(row) row(“NAME”).ToString.Trim.Equals(“1”)).CopyToDataTable()

Cheers @akv

1 Like
13

the reason is you were unable to filter it using that!!!

The LINQ used is to filter datatable and you need to provide it equal as what exactly :slight_smile:

Have a great day :slight_smile:

14

still confused can you write the query

1 Like
15

Is correct @akv

The query is used to compare and store it in a datatable

16

image

Also uncheck the solution marked earlier

17

Kindly have a view on this buddy
@akv

18

error is coming regarding boolean type

Screenshot%20(33)
Screenshot%20(33)1920×1080 207 KB

1 Like
19

@akv

Can I have a clearer picture of the intend of your query!!!

  • Are you basically trying to filer the NAME folder with the one’s having “1”
  • Are you just intending to remove the 1 if it exist in the column “Name”
20

Fine if we want to get all the rows of column Name whose values equals to 1
then
we can use a simple assign activity like this
dt = dt.Select("[NAME] = ‘1’ ").CopyToDatatable()

simple isnt it
Cheers @akv

21
<?xml version="1.0" encoding="utf-16"?>TrueTrueTrue[xyz][dt1.AsEnumerable.select(Function(row) row(“NAME”).ToString.Trim.Equals(“1”)).CopyToDataTable()]