Wildmatch alternative in Set analysis

Mon, 12 Nov 2012 21:09:47 GMT

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!

Re: Wildmatch alternative in Set analysis

Mon, 12 Nov 2012 21:59:51 GMT

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))