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!
