Skip to main content
Announcements
Global Transformation Awards submissions are open! SUBMIT YOUR STORY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Delete First Record in Data Load

Hello,

I am attempting to load a table, but I need to delete the first record. My header is properly identified, but the first row below it needs to be removed in the data load.

How do I go about doing this?

1 Solution

Accepted Solutions
maxgro
MVP

load *

from yourtable

where recno() <> 1;

View solution in original post

1 Reply
maxgro
MVP

load *

from yourtable

where recno() <> 1;