Excel reader transformation problem

Hi,

With Knime 4.3 I found a problem using the new excel reader in a loop. I have multiple table Excel table with the same structure that I need to consolidate (through a loop), but the problem with new excel reader is that for my first table the amount column is read as an Integer but the second table in the loop the amount is defined as Double which cause the loop to fail at the excel reader level as is it can’t read the Double as Integer. Even with the enforce type unchecked, the loop fail, I think that transformation tab option are too strict, it should allow to choose a type we need and not enforce the one it chooses by itself.

The only way to resolve to resolve the problem for me is to you use the deprecated version of excel reader

Thank you

@Barod is it the same file, but different sheets that you’re reading?

Best
Mark

Yes exactly, the loop is going through all excel sheets. I need a way that I don’t have to modify the excel source
thanks

Hi @Barod,

this is actually a bug in the current reader, more details can be found in this post.

Best,
Simon

3 Likes

Hello @SimonS,

Can your workaround be adapted for my case ?
image

Best,
Barod

Hi @Barod,

you need to use a different path variable when configuring the Excel reader. E.g., copy the file to another location and use that path as variable. Then configure the Excel Reader. Afterwards, change your path variable back. This will cause the Excel Reader to re-calculate the spec in every loop iteration.
If there are still issues, increase or remove the limit of rows that are scanned on the Advanced Settings tab.

Best,
Simon

3 Likes

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

Hi @Barod,

the workaround is not required anymore with v4.3.1. We have added a new option, see here.

Best,
Simon

2 Likes