Format: and()
Calculate the logical conjunction of boolean value . Please refer to Table 4.8 on boolean value table with NULL values.
$ more dat1.csv id,b1,b2,b3 1,1,0,1 2,1,1,1 3,1,,1 4,1,1,1 $ mcal c='and($b{b1},$b{b2},$b{b3})' a=rsl i=dat1.csv o=rsl1.csv #END# kgcal a=rsl c=and($b{b1},$b{b2},$b{b3}) i=dat1.csv o=rsl1.csv $ more rsl1.csv id,b1,b2,b3,rsl 1,1,0,1,0 2,1,1,1,1 3,1,,1, 4,1,1,1,1
Specify columns names that start with b as in (b1,b2,b3) using a wildcard in column name such as "b*".
$ mcal c='and($b{b*})' a=rsl i=dat1.csv o=rsl2.csv #END# kgcal a=rsl c=and($b{b*}) i=dat1.csv o=rsl2.csv $ more rsl2.csv id,b1,b2,b3,rsl 1,1,0,1,0 2,1,1,1,1 3,1,,1, 4,1,1,1,1