Row Duplicate from Int16 overflow

Has anyone experienced a row duplicating 65,535x in their output to excel?

The canvas pushes the right number of rows to the output tool, but the output tool seems to hit an Int16 overflow duplicating some rows 2^16x.

Thanks to @Claje for identifying this was an Int16 overflow issue.

Workflow

Output

Accepted answers

JoshKushner

After extensive testing of this issue, the row duplication originated from a single duplicate row cascaded day-over-day, joined twice in each iteration.(256*256=2^16).

Closing this out confirming it is not an Alteryx issue.

All comments

danilang

Hi @JoshKushner

Can you provide a link to the original post?

Dan

JoshKushner

Hi Dan,

Could you please clarify? This should be the first thread with this topic.

If this is regarding a link to the original workflow, that unfortunately can't be provided.

Sorry this is pretty unhelpful.

After testing, it seems like a highly unique issue. At this point I'm most interested if anyone else has seen this specifically happen to them.

Bug specifics:
-exclusively occured with a file name, data combination
-exclusively occured writing to a .xlsx file (not legacy)

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703