Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi team,
I am calculating "LOB Criticality" value on the load, and i want to call it back on the same load to do another calculation but it is not working:
LOAD
[name]
[LOB Field]
[criticality]
If ([LOB Field]=1, 'ok','bad') as 'LOB Criticality'
if (len(trim([LOB Criticality]))=0,'blocked','not blocked') as 'blocked Y/N' -- this line is giving me an error. The "LOB Criticality" calculated field seems to be called in the wrong way but i dont know which should be the appropiate one
If someone can help, that will be really helpful
Hi.
You can use preceding load in this.
Please note that field names with spaces should be in square brackets.
Data:
load
*
, if (len(trim([LOB Criticality]))=0,'blocked','not blocked') as [blocked Y/N]
;
LOAD
[name]
,[LOB Field]
,[criticality]
, If ([LOB Field]=1, 'ok','bad') as [LOB Criticality]
inline [
name, LOB Field, criticality
a, 0, 1
b, 1, 0
];
Hi.
You can use preceding load in this.
Please note that field names with spaces should be in square brackets.
Data:
load
*
, if (len(trim([LOB Criticality]))=0,'blocked','not blocked') as [blocked Y/N]
;
LOAD
[name]
,[LOB Field]
,[criticality]
, If ([LOB Field]=1, 'ok','bad') as [LOB Criticality]
inline [
name, LOB Field, criticality
a, 0, 1
b, 1, 0
];