Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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
Partner - Champion III
Partner - Champion III

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_

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
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago
jonathandienst
Partner - Champion III
Partner - Champion III

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
gshockxcc
Creator
Creator
Author

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