Discussion board where members can learn more about Qlik Sense App Development and Usage.
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.
Go to Solution.
RowNo()n references output lines. You need RecNo() instead.
Where RecNo() > 1;
Maybe this will be helpful:
RowNo() as ID;
(txt, codepage is 1252, embedded labels, delimiter is ',');
Resident Your_Table_Temp Where ID <> 1;
Brilliant! Thanks, Jonathan. That's exactly what I was looking for.