| foreach p* [eval val='<>' | lookup wkst_risk_control asset_risk_position AS 'val']
I have 19 separate p extraction fields called p0-p18. I am looking to loop through each of the field names called p* and do a lookup of the name of the field itself from the lookup table wkst_risk_control to get the supplemental data. I am struggling and missing something. Is foreach
the best way or is there a more elegant method?
Something like this should work
...| foreach p* [ lookup wkst_risk_control asset_risk_position AS "<<FIELD>>"]