Exclude rows from the data

Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have the below set of data (<Time, Column1, Column2,Column3>)where Time should be the primary key but since there are duplicates in Time. I have to remove the first occurrence of 'Time' and consider the second or the last occurrence.

Time	Column1	Column2	Column3	RowNo()
25/10/16 8:00:00 PM	2	3	4	1
25/10/16 8:00:00 PM	3	5	6	2
25/10/16 9:00:00 PM	4	6	3	3
25/10/16 10:00:00 PM	2	4	9	4
25/10/16 10:00:00 PM	4	7	8	5

For this, I added RowNo() to the table and thought of considering the row with Maximum value for a particular Time.

Is there any way to remove the first occurrence from the data itself and get the below result in the LOAD Script.

Time	Column1	Column2	Column3	RowNo()
25/10/16 8:00:00 PM	3	5	6	2
25/10/16 9:00:00 PM	4	6	3	3
25/10/16 10:00:00 PM	4	7	8	5

Thanks and Regards,

Anjali Gupta

Re: Exclude rows from the data

maxgro — Thu, 27 Oct 2016 18:40:43 GMT

Source:

LOAD

Timestamp#(Time, 'DD/MM/YY hh:mm:ss ff') as Time,

Column1,

Column2,

Column3,

[RowNo()]

FROM

[https://community.qlik.com/thread/237954]

(html, codepage is 1252, embedded labels, table is @1)

;

Final:

NoConcatenate load * Resident Source

Where Time <> Peek('Time')

order by Time desc;

DROP Table Source;

topic Exclude rows from the data in QlikView

Exclude rows from the data

Re: Exclude rows from the data