Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

gshockxcc
Contributor

Omit rows from table load; not working

I am trying to load data with headers in row 1, short description in row 2, data in rows 3 ... 86,400, etc.  I want to omit row two only.  I'm trying load as follows:

(txt, codepage is 1252, embedded labels, delimiter is ',', Where RowNo() <> 2);

I have also tried:

(txt, codepage is 1252, embedded labels, delimiter is ',')

Where RowNo() <> 2;

No matter which method I try, I get the same result.  See attached.

1 Solution

Accepted Solutions
MVP
MVP

Re: Omit rows from table load; not working

RowNo()n references output lines. You need RecNo() instead.

(txt, codepage is 1252, embedded labels, delimiter is ',')

Where RecNo() > 1;

3 Replies
thiago_justen
Valued Contributor III

Re: Omit rows from table load; not working

Kristan,

Maybe this will be helpful:

Your_Table_Temp:

Load

*,

RowNo() as ID;

Load

*

From Your_Text_File

(txt, codepage is 1252, embedded labels, delimiter is ',');


Final_Table:

Load

*

Resident Your_Table_Temp Where ID <> 1;


Cheers

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
MVP
MVP

Re: Omit rows from table load; not working

RowNo()n references output lines. You need RecNo() instead.

(txt, codepage is 1252, embedded labels, delimiter is ',')

Where RecNo() > 1;

gshockxcc
Contributor

Re: Omit rows from table load; not working

Brilliant!  Thanks, Jonathan.  That's exactly what I was looking for.

Community Browser