Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
MVP
MVP

Re: Delete First Record in Data Load

load *

from yourtable

where recno() <> 1;

1 Reply
MVP
MVP

Re: Delete First Record in Data Load

load *

from yourtable

where recno() <> 1;