Masking Match

[clio]

Hi everyone,

I want to do a masking match by designing different transformation parameter in Alteryx for matching. Wonder if it is possible?

Example:

I want to create a datasheet to have all transformation pattern of the wordings with only column "Name" and do the transformation in Alteryx.

Name	Alteryx Transformation 1	Alteryx Transformation 2	Alteryx Transformation 3
Peter Simpson Motor	Peter S* M*	Peter S****** M****	P* S* M*
Mary Lord	Mary L*	Mary L***	M* L*
Simon Royal Kota Loi	Simon R* K* L*	Simon R**** K*** L**	S* R* L*

Then I would like to match any of the above pattern to description

Description	Match
From Peter S* M*	Yes
To Simon R*** K*** L**	Yes
From Mary L**	No
To Peter S* D*	No
From M* L*	Yes
To Simon	No

Would someone like to offer some help to me? Thanks.

[danrh · Accepted solution]

There's likely some fancy way to do this with Regex, but here's a go without:

I'm doing a find and replace, then checking to see if there are any more asterisks left over to determine if there was an exact match.

Note that the tools in the container are reproducing what you already have as your transformations --- remove if you already have this built out.

Hopefully this gets you close.  Let me know if you need clarification on how it's working.

[clio]

Thanks so much for the help! @danrh