CopyToDatatable option is not coming

Help
, ,
1

Hi All

I am using the select method to filter the date column and finally want to do CopyToDatatable and assign it to a datatable in the Assign activity.

But the CopyToDatatable option itself is not coming and only CopyTo is coming. Why is it so ?

1 Like
2

Hi friend

Make sure you have it like this

dt1.Select(“your expression”).CopyToDataTable

3

yes, still not coming.

1 Like
4

Can you post your expression here?

5

@kkpatel

If you write CopyToDataTable then is it giving any error ?

6

@kkpatel

You should try like this my friend

dt.Select(“[Column1]=‘Column1Value’ AND Column2 > ‘Column2Value’”).CopyToDataTable

Make sure to change the conditions as you want

7

Did you try that? Is it working @kkpatel ?

8

Hi @lakshman @cybzom @Palaniyappan

image001

Please check the above screenshot. I am working in enterprise edition.
[Requested] is the date column name. dt_irc1 is the data table name.

1 Like
9

HI @kkpatel,

Inside the expression Editor , the intellisense will not show the CopyToDatatable method. But when you put and press ok buttom. It will accept it.

Regards
Balamurugan.S

2 Likes
10

Ok will try. Can you also tell me if the spression is correct to filter a the date column ?

11

Hi
Add this assembly reference to your xaml by opening the main xaml with notepad (right clcik) and mention that extensions
For reference

Then we will be able to see
Or sometimes we won’t be able to see but if .CopyToDatatable() is mentioned the error will go
And your expression looks perfect please go ahead

Cheers @kkpatel

4 Likes
12

Thanks @Palaniyappan. Its coming now.

1 Like
13

Cheers @kkpatel

14

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