Loop End: String, rather than Integer?

I have a loop that runs many hours, but eventually dies because the data-type of column is being seen by “Loop End” as integer, even though I convert it to string.

It works fine as long as the integer (in the string) is contained within 32 bits, but after it gets beyond an “int”, “Loop End” complains.

Is there a way to ensure that what “Loop End” sees is really a string, and not an integer? I use “string($id$)” in a “String Manipulation” node, just before my “Loop End”, but I still get this error: ERROR Loop End 0:10 Execute failed: Input table’s structure differs from reference (first iteration) table: Column 0 [id (Number (integer))] vs. [id (Number (long))]

Hi @bassman,

does it help if you select the config options “Allow variable column types” and “Allow changing table specifications”? This way i think it should totally ignore the column type.

Best,
Michael

1 Like

Actually, I found that I was “feeding” a column to “Loop End” that I didn’t need, so I substituted it with a more stable string variable (manufacturer name).

Still, this is the sort of thing I’d like to get a handle-on, and I will definitely retain your advice for “next time”… :slight_smile:

Thanks for the quick feedback!

Shameless plug: I really can’t believe how awesome KNIME is, along with the great support community!

3 Likes