Hi,
How can I extract 2 values from fieldA in a lookup and ignore the rest then count as total
Try:
| inputlookup aaa.csv where fieldA IN ("staff", "contractors") |stats count
Try:
| inputlookup aaa.csv where fieldA IN ("staff", "contractors") |stats count
Thank you,