I have an excel sheet in which i have defined formulas for each of the CODE as follows:
AGE is a column name in the same table
How can i use the THRESHOLD as a formula and then use it to define a dimension. Something as below
The applymap will return the formula and then i can apply it in the if condition. Is there a way to use it?
I am not still clear, what your'e trying to achieve.
MAP_THRESHOLD: Mapping LOAD * INLINE [ THRESHOLD, CODE AGE>15, AJS AGE<3, AJSS ]; Age: Load *, If (Len(applymap('MAP_THRESHOLD',Age_Bucket))>=1,1,0) as Dimension, applymap('MAP_THRESHOLD',Age_Bucket,'#NA') as CODE; LOAD *, If(Age>15,'AGE>15', IF( Age<3, 'AGE<3')) as Age_Bucket INLINE [ Age 1 2 66 16 7 ];
Thanks for the response.
Actually what I want is to have an kind of formula as a text in the field (AGE was just an example)
AJSS, SALES <50
I want to read the formula and then apply it as a condition. The applymap will give me the formula but how can i apply the formula as a condition.
applymap('MAP_THRESHOLD',CODE,null()) will give me the FORMULA
if(applymap('MAP_THRESHOLD',CODE,nul()),1,0) should give me the following
but the challenge it is that it is returning text and i cannot use SALES>100 as formula.
Hope this clears.
Check this, using evaluate function.
Map: Mapping LOAD * INLINE [ CODE, FORMULA AJS, SALES>100 AJSS, SALES<50 ]; SET vEval = Evaluate($1&$2); Data: LOAD *, If($(vEval(SALES,Evaluator)),1,0) AS Validate; LOAD *, Mid(ApplyMap('Map',CODE),6) as Evaluator INLINE [ CODE,SALES AJS, 55 AJA, 89 AJS, 110 AJSS, 40 AJSS, 90 ];
PFA for ref.
Did Hirish's last comment and example app solve your issue? If it did, be sure to give him credit by clicking the Accept as Solution button on the post. If you are still stuck or you did something else to solve things, it would be great if you can post that and mark that as the solution...