Different results Gallery vs Local workflow runs

[RPeeters]

Hi all,

I have a really strange issue with one workflow, namely that he results differ when I run it locally as to when I run it in our gallery.

Query:

Select TNA_Critical.* From TNA_Critical

To an alteryx database file.

Results:

• Locally run workflow:
• Same size output on two different network locations and on my local laptop drive.
• Gallery workflow:
• Same size on two different network locations (same as for the locally run).
• However the sizes are different between the Alteryx app local vs Gallery run.

Attached the workflow and results. 

The issue is also there if I only pull and push the top left (SQL Critical Table) into the alteryx db file, so I know the joins do not create the issue.

Whats going on?