Alteryx Analytic App Error: Invalid Row Number Encountered

[andrewpoortenga]

Hi, I am running into an error running my Alteryx workflow. The file referenced (83) does not seem to have changed in any way from prior month (formatting wise) but I am now seeing an error. It has around 130k records so nothing that should be trouble. Anyone know what's going on?

[earth2joy · Accepted solution]

Hi Andrew,

This turned out to be a hidden file corruption issue. Online research revealed that if a brief power outage or other type of interruption occurs while a file is being downloaded from a database, the resulting Excel output will contain a hidden corruption. It is hidden in the sense that the Excel file can be opened in Excel, and used as an Excel document, but will be revealed when being read by Alteryx and perhaps other data wrangling and visualization tools, like DataIku, PowerBI, and Tableau. The problem was solved when your colleague downloaded the file a second time.

Thanks so much for asking this question!

Joy