input lookup aaa.csv fieldA=staff and fieldA=contractors |stats count

[nathanluke86]

Hi,

How can I extract 2 values from fieldA in a lookup and ignore the rest then count as total

[manjunathmeti · Accepted solution]

Try:

| inputlookup aaa.csv where fieldA IN ("staff", "contractors") |stats count

[nathanluke86]

Thank you,