Hello Everyone, I am in situation where in I will send the results to one lookup file and from there again I need to take tail 2 two rows to display as a summary in my Dashboard. Below is the exact scenario. I have a search which compares last week and this week data and produces the results something like below. Date Active Inactive Deleted Added 10/25/2021 80 20 10 15 I need to send the results calculated in above search to one lookup file . Like that I will keep on sending every week. It will be like below after some weeks say 3 weeks. Date Active Inactive Deleted Added 10/25/2021 80 20 10 15 11/1/2021 78 22 8 11 11/8/2021 83 18 9 6 so above is the lookup file, then I need to use the the created lookup as input in the same query to perform some calculations (i.e,. I need to take tail 2 and display it as summary of last 2 weeks). Tried something like below. But it didn't worked. Could someone help me on this. <search > | outputlookup test1.csv | search inputlookup test1.csv | tail 2
... View more