Student_name Status marks
john fail 30
han fail 10
ram fail 20
vish Pass 50
han Pass 90
ram Pass 50
The output should be - as ram as passed in second attempt
Student_name Status marks
john fail 30
han fail 10
hi @sunil04mca , you can use this after your main query
....| stats latest(status) as status by user | search status="fail"
hi @sunil04mca , you can use this after your main query
....| stats latest(status) as status by user | search status="fail"
@Nisha18789 This query will work for above table , but when i am trying to combine and extract from 2 tables , i am not getting.
table-1 student name , marks and status,
table-2 we have student details. should extract address and DOB.
Need a report as student-name, status,address and DOB.
Can u pls help on this
Thanks @Nisha18789 , this is working as expected..
use stats latest(status) as status | search status=fail