Trouble with index function in a filter

Benny Domeij · Post by **Benny Domeij** » Thu Oct 16, 2008 5:06 am

I have trouble with an index function in a filter. The where condition is:

INDEX('KM,CM,',produktomr:',',1) =1

I want only rows from the column produktomr that is equal to KM or CM.

I have seen a post in the forum that discusses solutions with locate and findstr, but I found those solutions hard to understand. If Index is not the best way please write 1-2-3 steps for me...

ArndW · Post by **ArndW** » Thu Oct 16, 2008 5:15 am

The Index function you gave will work. What is your probelm with it?

Benny Domeij · Post by **Benny Domeij** » Thu Oct 16, 2008 5:23 am

I get this error message:

Filter_131: Parse error: Expected comparison, 'between', or 'like' operator, got: "["
Parse error: Expected boolean operator (and, or) got: "1".

ArndW · Post by **ArndW** » Thu Oct 16, 2008 5:29 am

Ahh, that is correct. the INDEX function won't work as a filter condition. Instead of a FILTER stage, use a transform stage with the INDEX() function in the constraints.