Hello,
I have a handful of tables that contain monthly reported data. Each table starts at a different Metric time, meaning table 1 starts the report 2015/1/1 while table 2 could be starting on 2015/3/1.
I am trying to filter out every first two rows from each table. I could manually go through every table and put
|where metric_date < ******
but I feel like there should be a way to automate this process.
Can anyone help if you have any idea?
Thank you ahead,
J
Hi.. sorry for the late accept.
head is the function I was kind of looking for, but how could I exclude the first rows instead of returning them?
AFAIK, there's no "official" way to do it.
I've only ever been able to do this with | streamstats count as c | where c>10
(hardly any performance impact).