HELP PLEASE, Server Omits Data and Layout from Rendered Excel File

Question

Hi everyone,

I hope someone can help me with this. My project is intended to output several sheets of data to a single excel file, each sheet of which has a simple layout. On the top, a summary report. On the bottom, the detail table. When I run this analytic app from Developer, it works perfectly. When I run it from Server, the summary portion drops out. I only see in the final excel files black cells with no data in them. See the attached App and its outputs.

To run this, all that you would need to change is to change the network address in Formula (2).

I hope to hear from someone!

Thanks,

Shen-Tat

QC_COMPARE_2021-08-27_145525.xlsx

QC_COMPARE_2021-08-27_145820.xlsx

PROJECT.yxwz

Shen-Tat · Answer

This is NOT a bg color issue. The data (if you look at the workflow I uploaded) do not pass through to the output file. Perhaps someone, other than the first person, who saw the relevant issue, can see this? I do not know how to more clearly paraphrase this. I don't care about the color. I care about the summary data, which is not printing on the output.

CristianoJ · Answer

This issue, DE33649, got fixed in the 2021.3 release as per the release notes at this link:

https://help.alteryx.com/release-notes/designer/designer-20213-release-notes

Shen-Tat · Answer

This is not a color issue. This is a DATA and color issue. I will correct for the bgcolor, however, the data are not rendering out of the tool. Do you know a resource for this?