Replace all the non-numeric values with 1 - and all the blanks with 0

Now that you mention it. It is possible I had a similar problem and just went about it by using a Regex string to filter columns with a variable:

Another alternative would be to use a reference column filter.

I would have to investigate further since in former versions of the column filter it has worked.

Maybe @ScottF or @ipazin could weight in and see what is going on. I might run some more tests.

1 Like