Wildmatch alternative in Set analysis

[#1]

Hi Guys,

I would like to make an expression using set analysis but the wild match function doesn't work in set analysis. My expressions looks like:

count({1<

Field1 = {'Lee'},

Field2 = {'type1'},

wildmatch(Field3 ,'*Architecture*','*Drivers and Electronics*','*DEC*')

  >}ID))

Wildmatch doesn't work here.

Can anyone please tell a way to achieve this?

Thanks!

[#2]

You can add a flag in the script.  For example:

LOAD

     Field3,

     Wildmatch(Field3,'*Architecture*','*Drivers and Electronics*','*DEC*') as Flag

Resident YourTableName;

Then for the set analysis you can use:

count({1<Field1 = {'Lee'},

Field2 = {'type1'},

Flag = {'1'}>}ID))