Extra row when selecting Table Files

[#1]

Hey guys!

I'm trying to import this simple Excel table to Qlikview:

but when I do this I get an extra row (see the last row on the next picture):

This is bad since the first column will be my table's dimension and, therefore, I will get an extra - meaningless - row on my table.

Anyone know why is this happening and how can I fix it? I'm sure there's nothing (any spaces) in the row below the last row of my Excel table. This has happened to me with a few different tables.

Thanks for the help!

[maxgro]

add a where to your load

where

     len(trim(dimMes5)) > 0

     ;

[#3]

Some times Qlikview will show up in the wizard if any empty spaces on the bottom lines.

In the wizard, you can use transformation step or check the length of any field to avoid the loading the empty space line  like below:

Where Len(Trim(dimMes5)) ;

[awhitfield]

Hi Mateus,

1. Does the extra row actually appear in you QVW?

2. Have you checked the cells in excel ARE actually empty?

3. Can you upload the actual xlsx?

Andy

[vardhancse]

Hi,

Once try to delete the entire row in excel and try lo reload now in qlikview.

some time some special characters might be there so that in qlikivew it might take as an extra row data.

[#6]

Thanks for the help Massimo!

But where would I insert this statement? Before the "From" statement? Because it's not working.

[#7]

Hey Andrew! First of al, thanks for the help!

1. Yes, it does. See the picture below (I have no idea of what the data on the extra column mean).

2. Yeah, I had already made sure they were empty, but I deleted ALL the cells except for the ones from the actual table, reloaded the script on qvw, and still the problem continues.

[maxgro]

load

     dimMes5,

     ....,

     ....,

     sortdimMes5

from

     [C:\Users.......................

     (ooxml, ..........

where

     len(trim(dimMes5)) > 0

     ;

[#9]

I was able to put the statement in the script, but it didn't solve the problem 😕

This is happening with a few different tables, on the same QVW document. Somo other tables, however, are working fine. I cleaned all the Excel tables once again, bur the problem still persists. No idea of what's going on.

[awhitfield]

Q 3 - Can you upload the excel sheet?

Andy