Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have the following expression in a Straigh Table:
=if(PPV.ProductID=ProductID, 1
,if(PPV.ProductID=PU.ProductID, 1
,if(PPV.ProductID=PQ.ProductID, 1
, 'No Match'
)
)
)
I am trying to make it searchable so I can see all non-matches. When click the 'Search' icon and type *No Match* nothing happens. Did anyone else ever experience this issue? Can anyone offer any advice on how to perform this search correctly?
Thanks!
i'd say use applymap function in your load script, then it will definitely be searchachle.
nicksatch,
Thanks for the suggestion, but the applymap function will not work for me in this instance.
Does anyone else have any other suggestions?
Thank you!