Excel reader is reading just first few rows

KNIME Analytics Platform
1

Good Day Knimers :green_heart:!

Now I am having an issue with excel reader. The node is not reading whole content, just in case I checked the same file in alteryx, it works fine.
In KNIME:
I was not able to upload it, so file in google drive:

image
image797Ă—703 29.1 KB

In Alteryx:

image
image1242Ă—607 38.3 KB

After checking in Alteryx I extracted sheet as an output, and I tried to read in KNIME, here it scanned and read properly.

So, can you help me read this file wo going to Alteryx
P.S. I did not change anything in the file itself (downloaded and started to read it)

Many Thanks,
Karlygash

2

Hi @Karlygash,

the Sheet you shared is private (at least i cannot view it :slight_smile: )

grafik

2 Likes
3

Just guessing based only on the screenshots, it looks like you have some header records at the top of the file. If you uncheck the box for “Table contains column names in row number X” and choose to read only data starting from, say, row 9, does it perform any better?

4 Likes
4

Hi, @ScottF . I tried it, but it is still no records

5

hi @AnotherFraudUser
sorry, i have changed access

7

I was able to download your file and do a quick check. Can you try unchecking the “Skip hidden rows” checkbox under the Advanced Settings tab? That seemed to do the trick for me.

5 Likes
8

@ScottF I think you are correct here. At least from another outside perspective this looks like the solution :+1:

4 Likes
9

@ScottF , wooow cool! thanks!!! :innocent:

1 Like
10

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.