topic Re: Extra row when selecting Table Files in QlikView

Extra row when selecting Table Files

Thu, 13 Aug 2015 18:03:49 GMT

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!

Re: Extra row when selecting Table Files

maxgro — Thu, 13 Aug 2015 18:13:40 GMT

add a where to your load

where

len(trim(dimMes5)) > 0

;

Re: Extra row when selecting Table Files

Thu, 13 Aug 2015 18:33:24 GMT

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)) ;

Re: Extra row when selecting Table Files

awhitfield — Fri, 14 Aug 2015 10:17:50 GMT

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

Re: Extra row when selecting Table Files

vardhancse — Fri, 14 Aug 2015 10:30:05 GMT

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.

Re: Extra row when selecting Table Files

Fri, 14 Aug 2015 14:22:23 GMT

Thanks for the help Massimo!

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

Re: Extra row when selecting Table Files

Fri, 14 Aug 2015 14:29:30 GMT

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.

Re: Extra row when selecting Table Files

maxgro — Fri, 14 Aug 2015 14:29:33 GMT

load

dimMes5,

....,

sortdimMes5

from

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

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

where

len(trim(dimMes5)) > 0

;

Re: Extra row when selecting Table Files

Fri, 14 Aug 2015 14:48:14 GMT

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.

Re: Extra row when selecting Table Files

awhitfield — Fri, 14 Aug 2015 15:19:45 GMT

Q 3 - Can you upload the excel sheet?

Andy

Re: Extra row when selecting Table Files

Fri, 14 Aug 2015 15:39:22 GMT

Did you add Where Len(Trim(dimMes5)) ; to your load script. ?

Re: Extra row when selecting Table Files

Fri, 14 Aug 2015 16:33:32 GMT

This is a different table, but the same problem is happening to it.

Re: Extra row when selecting Table Files

Fri, 14 Aug 2015 16:45:10 GMT

Yes I did, but it didn't change anything.

Re: Extra row when selecting Table Files

Tue, 18 Aug 2015 17:34:42 GMT

Any new ideas Andy?

Re: Extra row when selecting Table Files

vardhancse — Wed, 19 Aug 2015 03:36:11 GMT

Hi,

Once try to copy entire data from the sheet and paste in another new sheet.

Now try to reload the data from the new sheet instead of new sheet.

Re: Extra row when selecting Table Files

Wed, 19 Aug 2015 13:19:26 GMT

Thanks for the help Sasi!

I did try to use a different sheet. It's not hard to do it because my sheets are all really simple. But anyway, this is happening to EVERY sheet I load to my Qlikview job, and that's about 12 of them. The curious thing is that, sometimes, when I'm loading a sheet, the pre-visualization on Qlikview doesn't show the extra row (such as it did in the first picture I posted), but, still, the extra row comes up when I build the Pivot Table.

Any other ideas?