topic Re: Alteryx desktop output different from Alteryx gallery output - Same workflow in Alteryx Server Discussions

Alteryx desktop output different from Alteryx gallery output - Same workflow

aileenr — Mon, 28 Jan 2019 16:01:36 GMT

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.

Re: Alteryx desktop output different from Alteryx gallery output - Same workflow

MarqueeCrew — Mon, 28 Jan 2019 16:05:04 GMT

@aileenr,

That feature sounds very interesting. Can you please try output to a CSV and see if you get the correct results?

Cheers,

Mark

Re: Alteryx desktop output different from Alteryx gallery output - Same workflow

aileenr — Mon, 28 Jan 2019 16:09:26 GMT

yes,

When I Output to a CVS I get the correct results.

Re: Alteryx desktop output different from Alteryx gallery output - Same workflow

MarqueeCrew — Mon, 28 Jan 2019 16:14:21 GMT

@aileenr,

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?

Cheers,

Mark

Re: Alteryx desktop output different from Alteryx gallery output - Same workflow

aileenr — Mon, 28 Jan 2019 16:18:42 GMT

The workflow is pulling from Microsoft SQL Server so there shouldn't be any hidden rows

And the output data writes to another SQL Server

Re: Alteryx desktop output different from Alteryx gallery output - Same workflow

MarqueeCrew — Mon, 28 Jan 2019 16:27:16 GMT

I thought that you said you were reading and writing to Excel. My apologies.

We determined that the output CSV files were equal. Have you tried to load those CSV contents to the SQL table?

Cheers,

Mark

Re: Alteryx desktop output different from Alteryx gallery output - Same workflow

aileenr — Mon, 28 Jan 2019 16:45:36 GMT

Hi,

I am using "Connect in DB" and then the workflow pushing it to the SQL Server, and using tableau to connect to the SQL Server and pushing that Data Source to my Tableau Server.

Are you saying that I output it to a CSV file and then push it to the SQL Server?

Re: Alteryx desktop output different from Alteryx gallery output - Same workflow

dwarakanathd — Fri, 14 Feb 2020 20:07:37 GMT

I encountered the same issue,
I published a tableau data source as output from my Alteryx workflow and the output is different when executed on Desktop and when run on Alteryx server.

On further investigation, in my case the Alteryx server output has made some of my measures(numbers) into string values. Where as from desktop the measures are numbers.

Please let me know where the glitch is and if you have a solution for it.

Re: Alteryx desktop output different from Alteryx gallery output - Same workflow

tanyaz — Fri, 02 Apr 2021 13:46:25 GMT

@dwarakanathd did you get this issue resolved? I'm having the same issue where the output file headers running from the server change and impacting the Tableau dashboards. However, running on desktop the field names stay consistent. I can't determine the reason and the solution. Thanks

there Re: Alteryx desktop output different from Alteryx gallery output - Same workflow

SFYODOR — Fri, 17 Jun 2022 15:41:45 GMT

Hi all, has there been any updates or did anyone find the way to resolve? I am also having an issue with different outputs in designer vs the gallery. Gallery is giving wrong output.