Format: product()
Calculate the product of the array of values in . NULL values are ignored, if NULL values exist in all items, the result will return a NULL value.
$ more dat1.csv id,v1,v2,v3 1,1,2,3 2,-5,2,1 3,1,,3 4,,, $ mcal c='product(${v1},${v2},${v3})' a=rsl i=dat1.csv o=rsl1.csv #END# kgcal a=rsl c=product(${v1},${v2},${v3}) i=dat1.csv o=rsl1.csv $ more rsl1.csv id,v1,v2,v3,rsl 1,1,2,3,6 2,-5,2,1,-10 3,1,,3,3 4,,,,
Use the wildcard character “v*” to specify columns starting from v (v1,v2,v3).
$ mcal c='product(${v*})' a=rsl i=dat1.csv o=rsl2.csv #END# kgcal a=rsl c=product(${v*}) i=dat1.csv o=rsl2.csv $ more rsl2.csv id,v1,v2,v3,rsl 1,1,2,3,6 2,-5,2,1,-10 3,1,,3,3 4,,,,