Data types differ in the numerous excel sheets

KNIME Analytics Platform
1

ERROR Loop End 0:36 Execute failed: Input table’s structure differs from reference (first iteration) table: Column 17 [HST (Number (integer))] vs. [HST (Number (double))]

HST is a tax and should be in double, however in some cases within the excel files it is saved as an integer. When I do a loop to stitch the various excel sheets together, I ran into the error stated above.

2

Take the “Round Double”-Node before loop end, so you can transform the HST *integer to HST *double.
Remember to overwrite the column (not appending suffix) and use Double as “Output format”.

2 Likes
3

Alternatively you can use Column Expression node with toDouble() function.

5 Likes
4

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