This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have a table uploaded on Qlik. I want to delete the first row and the last row.
I have deleted the first row in the following way:
FROM [lib://Donation Sheets]
(html, codepage is 1252, embedded labels, table is @1)WHERE RecNo() > 1;
However, I am unsure about deleting the final row also. How should this be done?
Thank you in advance,
I have been able to solve the issue by doing the following:
FROM [lib://Merchandise Sheet]
(html, codepage is 1252, embedded labels, table is @1) Where RecNo()<> 1 AND 5.
I only needed to use the AND function. As I thought, it was very simple!
View solution in original post
I think you need to get the count of the rows and use that in your where condition.
WHERE RecNo() < select Count of rows from the table ;
Thank you for your response. Please can you help me further, what will it been if, say, I want to get rid of row 1 and row 5?
Try Like this,
load * Inline [
load Count('id') as countid Resident AC;
Load id as idtest, sales1 as salestest Resident AC Where RecNo()<>1 and RecNo()<>$(vcount);
Thank you for your suggestion. It is not creating a inline table a bit over-complicated? Especially seeing as I can get rid of a single row just using WHERE RecNo() > 1;? Isn't there a simpler expression?
First load the data from database or excel anything ok
select * from table name or load * from excel;
after count rows like below
next use this
once again load full table or resident and apply where condition
If you refer to rownumbers, it might be easier to include in your table, like:
RECNO() AS RowNo,
NOCONCATENATE LOAD * RESIDENT BaseTable WHERE NOT MATCH (RowNo, 1, 5);