Hi All,
I am trying to implement the below SQL script in QlikView to get the latest sequence number and facing performance issue while implementing "AutoNumber" as an equivalent for rank(). Table contains around 1 Million record.
SQL Script:
select id, response_id, seq_num, create_dt, sent_date,
rank() over(partition by id order by sent_date,response_id) as seq_num
from table_name where seq_num=1;
QlikView Script:
Load
id, response_id, seq_num, create_dt, sent_date,
AutoNumber (RowNo(),id ) as new_seq
from
table_name.qvd(qvd)
where seq_num=1;
Could you please advise on how to overcome the performance issue?
Thanks in advance.
