AnsweredAssumed Answered

FilterValues Function

Question asked by AlexXander on Feb 27, 2012
Latest reply on Feb 27, 2012 by AlexXander

Title

FilterValues Function

Post

OK I've been using the FilterValues Function as 

Field E = FilterValues (Field A; ValueListItems ( Get ( FileName ) ; "List Field D") )

And this worked great up untill I was no longer able to keep Field D = List(List(Test 2::Field B);List(Test 2::Field C)) -That made up the Value List "List Field D"- As an indexed field.  

Now I figured I would just do this:

FilterValues ( Field A; Field D) but that returns all empty record so I tried FilterValues ( Field A; Field B) and FilterValues ( Field A; Field C) and it was the same result, just a list of empty cells when there are clear matches beween the fields. 

Does anyone know how to get this to work.

Screen_Shot_2012-02-27_at_8.25.56_AM.png

Outcomes