topic Re: Remove the last row / Max Row in QlikView

Remove the last row / Max Row

Wed, 11 Feb 2015 04:44:51 GMT

I have a table of file names and I want to load all files except last file (max number). I will use "for loop" to load files. How can I remove last row from the table

FileName

I want

FileName

Re: Remove the last row / Max Row

Wed, 11 Feb 2015 06:46:23 GMT

Please have a look this one.

Thanks

Re: Remove the last row / Max Row

Wed, 11 Feb 2015 06:58:53 GMT

Hi Naskar,

Can you please explain the procedure to achieve.

As I'm using personal edition.

Thanks in Advance.

Regards,

Pavan.

Re: Remove the last row / Max Row

Wed, 11 Feb 2015 07:31:41 GMT

Please try this script :

Loading data form Source :

Temp_Data:
LOAD FileName,
rowno() as Recno
FROM
Data2.xlsx
(ooxml, embedded labels, table is Sheet1);
Find the last record form source:
LoadMax:
Load max(Recno) as Recno1 Resident Temp_Data;

Let vMaxNo=Peek('Recno1',0,'LoadMax');

Data:
NoConcatenate
LOAD
*
Resident Temp_Data where Recno<>$(vMaxNo);

Drop tables Temp_Data,LoadMax;

Thanks