Index('AAA', 'A') returns 1. So does Index('AAA', 'AA') etc. I would like that only something similar to 'A*" would return 1 (or TRUE). In your example, I would like 'B' NOT to match with 'ABC'. Basically I need to be able to use wildcards.
If you think Index should work, could you provide a quick example? Thanks!
Guess I just don't understand what you're trying to do.
Have a look at what this does:
LOAD Dim, Mask, min(Result) as Result Group By Dim, Mask;
LOAD *, if(WildMatch(Dim,MatchValue), -1, 0) as Result;
LOAD Dim, Mask, Subfield(Mask,';') as MatchValue INLINE [
This solution does seem to work and it's actually the one I'm currently using myself.
While this does work fine, I'm wondering if there's a way to do it without extracting the individual field values via SubField(). I believe SubField creates a new row for each individual value and this might cause some issues if there's a lot of data (the example I provided is a lot simpler than the actual scenario I need this for).