How to filter column which is filled with False init with .Select and copytodatatable

how to filter column which is filled with False init with .Select and copytodatatable

1 Like

ExtractDataTable.Select(“[Column Name]=’False’”).copytoDatatable

2 Likes

Hi @ryava_santhoshi,

Datatable.select(" ColumnName=‘False’ ").copytoDatatable

Please try this.

Thanks!

2 Likes

i tried both before…those are not working…is shud filter only FALSE values in that column.
please let me know any exact solution

1 Like

Refer the below link

1 Like

Pls refer this example,

select_query.zip (8.1 KB)

2 Likes

thank you all

1 Like

declare a data table variable for example newDataTable
Use assign activity newDataTable = existingDataTable.Select(“ColumnName=‘FALSE’”).CopyToDataTable()

If column name contains any spaces then mention as [column name]
Take care of case sensitivity of FALSE.

Hope this will help you

Regards,
Pathrudu

1 Like