Wildmatch using inline table as value reference

[#1]

What is the syntax in a load script to reference an inline table as a wildmatch value reference? When I try to load this syntax the script error says it can't find the field [Mfgs] but this is not a field its an inline table I loaded previously.

Mfgs:

Load * INLINE [
Customer Input, Customer
X, X

Y, Y];

WildMatch(Title, '*'&[Mfgs]&'*') as [Customer Name]

[rwunderlich]

The syntax is a bit complex. I have a complete example here:

Qlikview Cookbook: Mapping With Wildcards http://qlikviewcookbook.com/recipes/download-info/mapping-with-wildcards/

You can also use Qlikview Components

CALL Qvc.CreateWildMapExpression (vMapExpr, 'Mfgs');

-Rob

http://masterssummit.com

http://robwunderlich.com

[#3]

Rob your link doesn't allow me to download the qvw, am I missing something?

[rwunderlich]

The linked page should contain a download button that looks like a down arrow next to the description. Do you get that?

-Rob

[#5]

Rob i was able to download the qvw, it was my use of an older IE Browser that caused the problem. However this seems very complex. I just want to be able to wildmatch values using an inline table to an existing field to create a new field. Does it really have to be this complicated?

[rwunderlich]

Yes

It's not as complex as it looks if you just copy the script that builds the wildmatch expression. Then fill in the table wiith your values.

[sasiparupudi1]

please check

How to group by a partial string value in a field