topic Differing Table Tool Output in Designer and Gallery in Alteryx Server Discussions

Differing Table Tool Output in Designer and Gallery

FrederikE — Mon, 15 Aug 2022 07:45:42 GMT

Hello together,

I ran into a problem when executing my WF on the Gallery. The table rendered to a .xlsx/.pdf carries different values on the Designer vs. the Gallery.

Local WF:

On Gallery:

As you can see, the values are messed up and do not show the actual value when executed on Gallery.

The input into the table tool are double values and are rounded by 0.01 (mentioning this bc. the values seem to cut off a few places and round it then).

I am doing the same thing for five other tables and they work perfectly fine, this is the only troubling one.

I know that I could change it to a string that could solve this, but I'd prefer to input it as a numerical value.

Can not add the WF in here.

Re: Differing Table Tool Output in Designer and Gallery

AndrewSu — Mon, 12 Dec 2022 20:52:13 GMT

@FrederikE , is this still an issue for you? What version of Server and Designer are you on?

Re: Differing Table Tool Output in Designer and Gallery

PanPP — Mon, 12 Dec 2022 20:59:53 GMT

Hi @FrederikE

You could experience this issue because of the comma in the numeric field.

I would replace the comma with a blank space (See below). After the formula tool, use a select tool to change the data type to a numeric data type.

Hope this helps, if it does please like this post/mark it as a solution.

Re: Differing Table Tool Output in Designer and Gallery

FrederikE — Tue, 13 Dec 2022 06:54:14 GMT

Solved

The issue that the Input was a .xls file and how that file is read in (comma vs. dot) depends on the computer locale. Since my PC is german but the server is english this caused the problem. Hard to troubleshoot...

Re: Differing Table Tool Output in Designer and Gallery

AndrewSu — Tue, 13 Dec 2022 23:11:31 GMT

@FrederikE , glad that this is resolved for you.

could you please mark this reply as a solutions so that we can cleanup/organize this thread?

That way others can benefit from our collaboration and your findings.

Thanks!