Analytic works, gallery results in zero records

Hi - i've written a chained analytic that follows this flow of three analytics:

1) Pull a list of applications from my database, de-duplicate, and store in a temporary Alteryx analytics database as "name" and "value" for use in a drop-down.

2) Pull the de-duplicated applications into a drop-down from the temp file (as External Source, see #1 above), pull report dates for these applications (one to many), and store these in a temporary Alteryx analytics database as "name" and "value" for use in a drop-down.

3) Pull the report dates into two drop-downs (both from the temp file as External Source, see #1 above), use the selections in two filter which should keep only the records for the selected dates, and then use a join to identify the outliers. Finally, export those records into an excel file.

#1 and #2 work in my designer and in the gallery. #3 correctly populates the dropdown in my designer and the gallery, but only produces results in the designer- no results are returned in the gallery. Anyone see anything like this before?

I've included a picture of analytic #3, since this is the only one with issues.

Output

Preparation

Chained App

Accepted answers

patrick_digan

@Csand have a look at my post here detailing the different ways to display results to the user: https://community.alteryx.com/t5/Alteryx-Connect-Gallery/How-do-show-my-output-in-the-gallery-after-workflow-execution/m-p/91057/highlight/true#M3174

When you publish a workflow to the gallery, you'll want to pay attention to the manage workflow assets option.

Can you post a pic of the output tools configuration if you're still having trouble?

patrick_digan

@Csand Fascinating! You'll need to report this to support@alteryx.com to have them fix the underlying issue.

I was able to replicate what you're seeing (works on the desktop but not on the gallery). I was able to login to the server and see the values that is being passed:

<WizardValues><Value name="Drop Down (7)">42:03:95</Value></WizardValues>

It should have sent

2018-02-06 18:42:03

The 95 part is coming from your value field. The issue is that the colon : is a special character that can be used to separate the name and value. While your desktop is correctly figuring this out, it appears that there is an error the gallery that is not processing this correctly. It finds the first colon (which is part of your date time) and thinks it should split the name and value there.

Until the issue is fixed, you would want to replace the colon with another character (ie replace([YourDateField],":","-")). You would put this in a formula tool right after your access input.

All comments

unknown

When you run the app in designer are you getting a result? Also, where is your file saving, on the same network as the gallery service? Have you saved the third workflow in the chain as an analytical app and checked off the output to show up in the results?

Try these things and see if any of those work (if not done already).

Csand

Hi Ryan,

Yes, when I run the analytic in designer I do get the correct results (and have the "on success - show results to user" checked). I don't change anything when publishing to the gallery regarding the save location, but it does seem like my temporary Alteryx database file is not saving to my network location that my designer uses when I execute within the gallery. Is it possible to figure out where the gallery is saving files to?

Note that I am a very new user here!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703