Load without removing duplicated record

[YJ_SG]

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?

[tresesco]

---

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. 

[yunus_emre · Accepted solution]

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

[YJ_SG]

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