FILTER TABLE

[Palaniyappan (Forum Leader)]

Hi
-in select method we can filter that condition and get the output datatable back
for more details on that

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…

–then use write range activity and mention the datatable variable as input and enable add headers property in the property panel of write range activity

hope this would help you
Cheers @Manoli_Puente