I would like to add all instances of a field within the same variable, named SynchronousExecution. Is there a better way to include all fields of the same type?
| eval QPACAWTE_0001 = if(isNull(QPACAWTE_0001), 0, QPACAWTE_0001)
| eval QPACAWTE_0002 = if(isNull(QPACAWTE_0002), 0, QPACAWTE_0002)
| eval QPACAWTE_0003 = if(isNull(QPACAWTE_0003), 0, QPACAWTE_0003)
| eval QPACAWTE_0004 = if(isNull(QPACAWTE_0004), 0, QPACAWTE_0004)
| eval QPACAWTE_0005 = if(isNull(QPACAWTE_0005), 0, QPACAWTE_0005)
| eval SynchronousExecution = QPACAWTE_0001 + QPACAWTE_0002 + QPACAWTE_0003 + QPACAWTE_0004 + QPACAWTE_0005
Thanks
... View more