topic Re: Load without removing duplicated record in QlikView

Load without removing duplicated record

YJ_SG — Sat, 16 Nov 2024 18:34:42 GMT

Hi, I am struggling on loading data from excel file.

The problem is some delivery records are same Qty and same date.

Qlikview will auto remove those 'duplicated' records, but actually they are not.

What I can do to stop auto removing?

Re: Load without removing duplicated record

tresB — Thu, 28 May 2020 10:57:12 GMT

Qlikview will auto remove those 'duplicated' records,....

NO, qlikview won't auto remove those. May be you are checking the records in table object and seeing them once, that is something causing the confusion. Table object shows unique combination records but at the back there could be multiple such combinations/records. Check the frequency of values in listbox to be sure.

Re: Load without removing duplicated record

yunus_emre — Thu, 28 May 2020 11:20:58 GMT

You can try Rowno() function in load statement. It may works

Re: Load without removing duplicated record

YJ_SG — Thu, 28 May 2020 12:37:08 GMT

Thank you. It works after add Rowno() in load.