Qlik Community

Ask a Question

App Development

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

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
gshockxcc
Creator
Creator

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
jonathandienst

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

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

Where RecNo() > 1;

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

3 Replies
thiago_justen
Specialist III
Specialist III

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
jonathandienst

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

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

Where RecNo() > 1;

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

gshockxcc
Creator
Creator
Author

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