Announcements
cancel
Showing results for
Did you mean:
Not applicable

## Wildmatch with a COLUMN/ Variable

Hi,

Below is the data I'm working on and the Results column is what I want to obtain.

Basically, I want to check if [PROD SKILLS] is inside the [SKILLS SET] then Results = 1 otherwise 0.

 PROD SKILLS SKILLS SET Results apple banana apple carrots 1 carrots carrots 1 banana carrots apple 0

Appreciate your help on this. Thank you!

1 Solution

Accepted Solutions
MVP

Since you were explicitely asking for a Wildmatch expression:

If(WildMatch([SKILLS SET],'*'&[PROD SKILLS]&'*'), 1,0) as WildMatch_Exp

PROD SKILLS SKILLS SET Varsha_Exp Sunny_Exp WildMatch_Exp
applebanana apple carrots111
bananacarrots apple000
carrotscarrots111
8 Replies
Specialist

if(substringcount([SKILLS SET],[PROD SKILLS])>0,1,0)

Varsha Solution might work but you cab try this too

if(substringcount([SKILLS SET],-[PROD SKILLS])>0,1,0)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
MVP

Or even with Index

If(Index([SKILLS SET],[PROD SKILLS])>0,1,0)

Sample Script:

Table:

If(SubStringCount([SKILLS SET],[PROD SKILLS]) > 0, 1, 0) as Varsha_Exp,

If(Index([SKILLS SET],[PROD SKILLS]) > 0, 1, 0) as Sunny_Exp;

PROD SKILLS, SKILLS SET

apple, banana apple carrots

carrots, carrots

banana, carrots apple

];

Sunny, Index and Subfieldcount two function working as Same or what?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
MVP

They work similarly but not the exact same.

Specialist

Doing the same thing with index is new for me. Thanks!

MVP

Since you were explicitely asking for a Wildmatch expression:

If(WildMatch([SKILLS SET],'*'&[PROD SKILLS]&'*'), 1,0) as WildMatch_Exp

PROD SKILLS SKILLS SET Varsha_Exp Sunny_Exp WildMatch_Exp
applebanana apple carrots111
bananacarrots apple000
carrotscarrots111
Specialist

If(WildMatch([SKILLS SET],'*'&[PROD SKILLS]&'*'), 1,0) as Stefan_Exp

Community Browser