Classification using operators

[#1]

Hey guys,

I have some Excels with classifications like the following one:

Field1	Field2	Field3	Field4	Concat Key	Result
Y	N	Entity1	0.5	Y|N|Entity1|0.5	Line1
N	*	Entity2	*	N|*|Entity2|*	Line2

What I do is:

• Create a concat key using fields from my dataset -> Field1&|&Field2&|&Field3&|&Field4 as Concat
• Store Concat Key and Result fields from Excel file into variables
• Apply a Pick+Wildmatch function

In fact, I am using "mappingwithwildcards.qvw" from Downloads - Rob Wunderlich Qlikview Consulting website.

The BIG issue is with this classification:

Field1	Field 2	Field 3	Field 4	Field 5	Result
= N	<> Y	= Entity7	= 0.5	= N	Line20
<> N	= N	<> Entity1	<> 0	= Y	Line30

I managed to separate the operator and the value like:

Operator_Field3	Field3
<>	Entity1

But now I have no idea on how to perform the matching. I can not simply modify the excel file lane by lane adding new rows for ALL the possible values because some fields have more than 50 different values... Nor using a concat key because operator can not be interpreted. It should be something dynamic.

Keep in mind that all the fields used in the Excel classification DO exist in my dataset. And the classification output must be Result value.

Any help would be really appreciated!

[#2]

Any idea?