Select List After a DETOUR is Empty

Hello -

Wrangling with this very straightforward issue for a few hours now. I have a simple analytics app that queries a sql database and then prompts then presents the user with three options to select from the database: by Account, by Last Name and by Email address. I do this via checkboxes and the DETOUR tool. The app works okay but strangely enough when I click on the Filter that occurs AFTER the detour tool (there are 3 of them for each checkbox) the field list that looked perfectly healthy before the Detour, disappears. When I click on the Filter plugged in after the Detour tool it is empty. What's even weirder is that I can enter a custom query and type in a field name that is flagged in red as an error (because it does not exist)...but the app works! It's as if the reference is resolved at run time. As weird as this is, I would be okay with it but I can't do anything with the data after the Detour (like format a PDF or Table) because no fields pop up in those tools. Is this a known Alteryx bug?

Notice in the illustration, that the first select is okay. It is displaying the full select list of input columns. All the others are empty or the only column, strangely enough, is “ACCOUNT”, but flagged as missing.

I have tired to attach the app but getting error "The attachment's detourapp.yxwz content type (application/octet-stream) does not match its file extension and has been removed." Any recs on that?

Thank you kindly,

Art Casale

DetourAppScreenShot.PNG

Workflow

Accepted answers

danilang

Hi @artzee1556

From looking at your workflow, the main purpose of the Interface tools is to filter records. Once the records are filtered, it looks like you're applying the same sub-workflow, i.e. you've copied the chunk from the select after the filter to the last formula with "'" + Value + "'" and pasted it after every detour. Instead of this process, try something like this

The UI has a Dropdown with the field names and a Single input box where the user types the value

The drop down is configured like this

Name:NAME
Login:LOGIN_ID
Account:ACCOUNT
Email:EMAIL

The value after the ":" is the field name from the Input box

Both UI tools are connected to the filter which has this expression [Name] = "Art". The Drop Down action replaces the string Name and the Input action replaces Art. Depending on the user's input the entire filter is changed to become [Name]="Charles" or [Email]="ABC@YAHOO.COM". This filters the records according to the field and criteria you want. No need to use detours or duplicate chunks of your workflow.

Dan

FilterByFields.yxzp

All comments

CharlieS

Hi @artzee1556

Detour tools are very strict. When a data stream is connected to a Detour side that is not enabled, nothing is passed to those tools, including field metadata. if you enable the detour route to those tools and run the workflow, do they work as expected?

Also, just to mention another nuance to Detour tools, they must be terminated by Detour End tools, or an Output tool. You may have this covered already, but I didn't see the last half of your workflow.

@artzee1556 wrote:
I have tired to attach the app but getting error "The attachment's detourapp.yxwz content type (application/octet-stream) does not match its file extension and has been removed." Any recs on that?

Analytic App must be exported to a compressed .yxzp format before they are attached on the Community. You can do this with Options > Export Workflow.

artzee1556

Thanks so much Charlie S for the quick response. The detour tool doesn't doesn't have alot of parameters to set. Right now they are all set to "Detour to Right". Is there an "enable" param I am missing?

CharlieS

@artzee1556 wrote:
Thanks so much Charlie S for the quick response. The detour tool doesn't doesn't have alot of parameters to set. Right now they are all set to "Detour to Right". Is there an "enable" param I am missing?

No, you've got it. I just used that term to describe the path where the data is flowing. If "Detour to the Right" is selected, then the "R" output is enabled.

danilang

Hi @artzee1556

The UI has a Dropdown with the field names and a Single input box where the user types the value

The drop down is configured like this

Name:NAME
Login:LOGIN_ID
Account:ACCOUNT
Email:EMAIL

The value after the ":" is the field name from the Input box

Dan

FilterByFields.yxzp

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703