topic Re: How to delete last row in QlikView

How to delete last row

Anonymous — Thu, 09 Nov 2017 14:15:30 GMT

Hi All,

How to delete last row in straight table in qlikview and Xtable in Qliksense.

Header coming two times.How to restrict that.

Ex: Raw Data

Date	Time	Ext No	Name	State	TeamNo
7/27/2017	01:00:52PM	3108	A	Sign-Off	31
7/27/2017	01:01:29PM	3165	B	Sign-Off	31
Date	Time	Ext No	Name	State	TeamNo
7/27/2017	01:13:11PM	3109	C	Sign-Off	31
7/27/2017	01:17:58PM	3124	D	Sign-Off	31

Qlik out put:

Date	Time	Ext No	Name	State	TeamNo
7/27/2017	01:00:52PM	3108	A	Sign-Off	31
7/27/2017	01:01:29PM	3165	B	Sign-Off	31
7/27/2017	01:13:11PM	3109	C	Sign-Off	31
7/27/2017	01:17:58PM	3124	D	Sign-Off	31
Date	Time	Ext No	Name	State	TeamNo

Thanks,

Krishna

Re: How to delete last row

Anonymous — Thu, 09 Nov 2017 14:29:47 GMT

Hello Krishna,

I think it is problem on script level. Could you present a sample?

Regards

Jacek.

Re: How to delete last row

Anonymous — Thu, 09 Nov 2017 14:35:30 GMT

Hi Jacek,

Script:

Load Date,

Time,

'Ext No'

Name,

State,

TeamNo

FROM [lib:// data.xls]

(biff, embedded labels, table is Sheet1$);

Thanks,

Krishna

Re: How to delete last row

Anonymous — Thu, 09 Nov 2017 14:38:24 GMT

Could you add data.xls with Sheet1 ?

Regards

Jacek.

Re: How to delete last row

Anonymous — Thu, 09 Nov 2017 14:47:51 GMT

Hi Jacek,

P F A.

Thanks,

Krishna

Re: How to delete last row

jpenuliar — Thu, 09 Nov 2017 14:51:34 GMT

Try this:

Temp1:
Load * Inline
[
Date,Time,Ext No,Name,State,TeamNo
7/27/2017,01:00:52PM,3108,A,Sign-Off,31
7/27/2017,01:01:29PM,3165,B,Sign-Off,31
Date,Time,Ext No,Name,State,TeamNo
7/27/2017,01:13:11PM,3109,C,Sign-Off,31
7/27/2017,01:17:58PM,3124,D,Sign-Off,31
];

temp2:
Load *
Where DeleteFlag = 0
;
Load *,
If([Date] = 'Date',1,0) as DeleteFlag
Resident Temp1;

Drop Table Temp1;
Drop Field DeleteFlag;

Re: How to delete last row

Or — Thu, 09 Nov 2017 14:53:26 GMT

Don't read lines that are just repeat of the headers.

Load Date,

Time,

'Ext No'

Name,

State,

TeamNo

FROM [lib:// data.xls]

(biff, embedded labels, table is Sheet1$)

WHERE Date <> 'Date';

Re: How to delete last row

micheledenardi — Thu, 09 Nov 2017 14:53:28 GMT

LOAD Date,

Time,

[Ext No],

Name,

State,

[Team No]

FROM

(ooxml, embedded labels, table is Sheet1)

where Date<>'Date' and Time<>'Time' and [Ext No]<>'Ext No' and Name<>'Name' and State<>'State' and [Team No]<>'Team No';

Re: How to delete last row

Anonymous — Thu, 09 Nov 2017 15:03:43 GMT

Thanks All

Re: How to delete last row

Anonymous — Thu, 09 Nov 2017 15:04:00 GMT

Yes, like Michele wrote, Krishna, you need to remove all possibilities.

Regard

Jacek.