Guys i have an excel like this ID Number Name 00081 John 00082 Kelvin 00083 Michael 17784 Doe 17790 Nicholas I want to filter the row, i only want the row that doesnt start with 008. I tried using filter datatable activity but it …

HI @Kelvin1 Then try like this in the Filter activity [image] Output Snap [image] Regards Gokul

Filtering row in data table

Yoichi (Yoichi) December 2, 2022, 8:17am 4

Hi,

Can you try to set PreserveFormat ON or DisplayValue in ReadRange, as the following?

Then, can you use Filiter DataTable?

Regards,

Topic		Replies	Views
Filtering Data Community question , community	13	544	December 13, 2022
Filter Data Table, keeping the original row numbers in Excel Help	3	3029	January 25, 2020
Filter data table starts with integer value Activities datatable , excel , activities , studio , question	5	1509	October 6, 2022
Need to filter a column in excel that starts with same first 2 numbers Help	9	2288	August 20, 2018
Filter rows using not like Studio datatable , excel , activities , datatable-filter	7	1172	August 3, 2021