copytoDataTable not working for LINQ query select menthod

Help Studio
, ,
1

hi guys

iam trying

when iam writing it , it doesnot show copytoDatatable, its only showing CopyTo

what should i do ?

Screenshot 2021-12-30 123230
Screenshot 2021-12-30 1232301307Ă—251 12.5 KB

to filter some data in datatable for that i used select query

2

Hi @Shoebmd

Can you please use any of the below ?

Thank you.

3

Hi @Shoebmd ,

There should be an IntelliPrompt for that Select Syntax as well, so You Could go ahead and finish the Expression and let us know if you get a Validation Exception. The Expression is valid as showed in the Image below, however the prompt may not appear sometimes.

image

You may need to edit or import Linq Namespace if there is a Validation Exception.

4

Try like this

Out_Dt = (
From row in Read_DT1
Where Cint(row(“Search Volume”).ToString)> 50
Select row
).CopyToDataTable

Thanks
Robin

5

0
01140Ă—672 28.1 KB

its giving this error always

6

how to do that plz tel me

7

You can follow the below Post on How to resolve it @Shoebmd

Let us know if you still face an Issue.

8

Can you try my above mentioned syntax
Where out_dt is variable type of datatable

9

thats not working

10

Can you share a snap of your flow

11

Hey @Shoebmd ,

Please check below thread.

1 Like
12

1
1992Ă—649 28.2 KB

please see this

and let me know what to do to get desired result

13

Go to import panel

And import System.Linq then try again

Thanks,
Robin

14

Tried that but its showing same error

15

Can you share your flow with dummy data

16

Please find the attached xaml file
test24.xaml (5.2 KB)
It works fine and i also attached input & output excel with you
Output24.xlsx (7.1 KB)
test23.xlsx (8.2 KB)
Hope it solves your issue

Thanks,
Robin S