Evaluating expressions that contain field names

[mattdistro]

Hi, I'm having some trouble with the evaluate() function in a data load.

We have some rules that we want to store in a QVD in the form of expressions that we can eventually join up to a different table in order to execute those rules and return the correct value.

I've been having trouble that I'm thinking is caused by referencing a field name in the expression. Maybe it's not supported, or maybe I've been doing something else wrong.

My data load in the test app looks like this:

Table:
LOAD * INLINE [
ClientCode, ExtraData, ActivityTypeRule
1320, ECOM, "If(WildMatch(ExtraData,'*ECOM*') = 1, 'ECOM Picking', 'Something Else')"
];

Table2:
Load
*,
Evaluate(ActivityTypeRule) as EvaluateResults,
If(WildMatch(ExtraData,'*ECOM*') = 1, 'ECOM Picking', 'Something Else') as RawExpressionResults
Resident Table;

Drop table Table;

The EvaluateResults column never returns the correct result, always "Something Else", however the RawExpressionResults column returns the expected value.

Is this even possible with the evaluate() function, or is there another way we could solve this inside Qlik Sense SaaS?