How to filter record from a table ?

[Uzumaki_N]

[Chanty4u]

Hi,

try below

Test:
load *
Inline [
Country, Status,rank
A,Comp,1
A,Comp,2
A,Comp,3
A,Comp,4
B,Comp,1
B,Comp,2
C,Comp,1
C,Comp,2
C,Comp,3
] ;

exit SCRIPT;