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 will make sure the schema of both of the tables is same), and then filter the original Data table using for each row activity and add the required row to the new data table by add data row activity.
Refer the attached Excel and main XML .
Thank you.
Filter NA values.zip (10.0 KB)
ashokkarale
Anil_G
Yoichi
yangyq10
postwick
chandreshsinh.jadeja
aravindbalineni123
Parvathy
aya
PRASHANT_GABHANE