topic excel upload rows with contents only in QlikView

excel upload rows with contents only

ahmedwank — Wed, 25 Nov 2020 16:16:04 GMT

hi all,

Every time i upload excel files, i notice qlik upload more rows than i have in my excel file.

for exemple here under i've an excel file with 17 251 rows and when i upload it to qlik i've 20 261 rows uploaded.

why this difference, how can i make it match with the real number of rows that i have ?

thanks a lot

Re: excel upload rows with contents only

johnmorgan13 — Sat, 23 Mar 2019 09:20:14 GMT

@ahmedwank wrote:
hi all,

Every time i upload excel files, i notice qlik upload more rows than i have in my excel file.

for exemple here under i've an excel file with 17 251 rows and when i upload it to qlik i've 20 261 rows uploaded.
why this difference, how can i make it match with the real number of rows that i have ?
live tv app

thanks a lot

Which Office(excel) do you have used? I faced these issues on 2007 excel file upload.

Re: excel upload rows with contents only

ahmedwank — Sat, 23 Mar 2019 09:53:35 GMT

i use excel 2016, the excel file is .xlsx

Re: excel upload rows with contents only

Vegar — Sat, 23 Mar 2019 19:07:47 GMT

It sounds really strange.
1. Check that you are reading data from the correct sheet in the excel.
2. Check that you don't have any hidden rows in the excel. QlikView loads hidden rows.

Re: excel upload rows with contents only

Vegar — Sat, 23 Mar 2019 19:16:46 GMT

If you in fact are loading more rows than exists in the excel then you should have duplicate rows in your table.

If your excel contains a primary unique key then you could create an straight table with the primary key as a dimension and the following expression:
Count(PrimaryKeyField) -1

If you get any value larger than zero then you have identified which rows that are loaded twice.

This is still not an answer to why, but you will be able to eliminate the routes you don't want.

Good luck
Vegar