Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Kohli
Creator II
Creator II

How to remove the first two rows in a table (Below the Header)

I have table like

Sid, Sname

I, C

I, C

1, Hari

2, Mahesh

3, Karna

I want output like 

 

Sid, Sname

1, Hari

2, Mahesh

3, Karna

Labels (1)
2 Replies
punitpopli
Specialist
Specialist

try this :
LOAD * INLINE [
Sid, SName
I, C
I, C
1, Hari
2, Mahesh
3, Karna

] where Sid <> 'I';
MohammedMustaq
Partner - Creator
Partner - Creator

You may try this..

Load * Inline
[
Sid, Sname

I, C

I, C

1, Hari

2, Mahesh

3, Karna
] Where RecNo()>2;