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

[ryava_santhoshi]

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

[anil5 (Anil Kumar Bandam)]

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

[kadiravan_kalidoss (Kadiravan K)]

Hi @ryava_santhoshi,

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

Please try this.

Thanks!

[ryava_santhoshi]

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

[anil5 (Anil Kumar Bandam)]

Refer the below link

URGENT: Filter datatable

Hello Abdel, I hope you found the solution if not then, try replacing the #Na with Na. if you are reading data from an Excel then the #Na value get’s replaced by a numeric string when read into a data table, and because of that the filter data table doesn’t work. To overcome this you can use IFERROR function in excel along with the required function that is populating the result in the desired column. From there on, you can create a new table which should be a clone of the previous table (this…

[kadiravan_kalidoss (Kadiravan K)]

Pls refer this example,

select_query.zip (8.1 KB)

[ryava_santhoshi]

thank you all

[pathrudu (Pathrudu Chintakayala)]

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