How to delete last row

[Anonymous]

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

[Anonymous]

Hello Krishna,

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

Regards

Jacek.

[Anonymous]

Hi Jacek,

Script:

Load Date,

         Time,

         'Ext No'

          Name,

          State,

         TeamNo

FROM [lib:// data.xls]

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

Thanks,

Krishna

[Anonymous]

Could you add data.xls with Sheet1 ?

Regards

Jacek.

[Anonymous]

Hi Jacek,

P F A.

Thanks,

Krishna

[jpenuliar]

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;

[Or · Accepted solution]

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';

[micheledenardi]

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';

[Anonymous]

Thanks All

[Anonymous]

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

Regard

Jacek.