hello
In host.csv, I have 4 fields : HOSTNAME, SITE, DEPARTMENT, CATEGORY
[| inputlookup host_OnOff.csv
| fields HOSTNAME SITE DEPARTMENT CATEGORY | rename HOSTNAME as host
] `OnOff`
| stats latest(_time) as _time by host SITE CATEGORY DEPARTMENT
As you can see, I need to cross these fields with the host there is in `OnOff` in order to stats the value after
But i have no values displayed
what is wrong please?
Is anybody can help please?