Dta table filter error

Help Robot
,
1

image
image958×514 27.4 KB

What is the error

2

Hi @Kuldeep_Pandey

Dtfilter is an array and you are trying to do CopyToDaTatable which is not possible… thats is the error.

If you want to add that array as row instead use add data row and pass the required datatable and thia array

Cheers

3

Hi @Kuldeep_Pandey change the data type of Dtfilter to data table type.

4

image
image930×416 17.2 KB

Tell me how to get output of filtered data

5

I have given data row type

6

Hi @Kuldeep_Pandey

This is the reason…the second assign returns you an array not datatable…instead of that use filter datatable and give the conditions… then you will
Get filtereddatatable directly

Cheers

7

@Kuldeep_Pandey use for each row in datatable and give dtfilter inside datatable field and access it row by row

8

Change it to system.data.datatable type or you can use filter data table activity and retrive all the filtered data by for each row activity

9

Do u know How to create new sheet in excel file

10

Hi @Kuldeep_Pandey

Write range will create the sheet if it doesnot exists

Cheers