How to Exclude Column Having #XL_EVAL_ERROR#

Dear All,
Post Applying Group Node, I am getting “#XL_EVAL_ERROR#” in few rows.
How I can Exclude them with Filer

If you just want to remove the rows, you could use the Row Filter node with this configuration:

If you’d rather convert the eval strings to missing values instead, you could use the String Manipulation node:

1 Like

More information on these types of operations is available in Chapter 3 of our E-learning course.

2 Likes

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.