This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
When I run an Alteryx workflow on my desktop and use the "Output Data" to publish to an excel file on my desktop then I get all of my data.
However when I publish the same exact workflow to the Alteryx Gallery and run it then I have records that are missing. I can't seem to find a common factor for the missing records. They seem to just be random. But I don't understand why the same exact workflow runs great on my desktop.
I use Tableau to pull up the data for both and get different results.
That makes everything clear. It is a Microsoft issue. That isn't truly helpful though. If the excel file is set to overwrite Sheet (Drop), I can't imagine why it is missing data. If it were append to existing sheet, I could see an issue. Is it possible that there are HIDDEN rows set in your workbook? Have you considered Overwrite File (Remove) if this is the only sheet?
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.