Join the Inspire AMA with Joshua Burkhow, March 31-April 4. Ask, share, and connect with the Alteryx community!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Radio button - prompt user to select Input File

Mariamfatimamirza
7 - Meteor

Hi everyone, I am working on a workflow, where I would like to give the user an option to select either txt file or xlsx file depending upon their use case. I am using radio button to allow them to select which format they would like to proceed with, and then allow them to select their input file and run the workflow. However, this just doesn't seem to work, and I am not able to see any output. Please see the screenshot attached. Can someone please share some insights on this?

 

I am attaching the workflow and also attaching the sample excel and text files.

17 REPLIES 17
gautiergodard
13 - Pulsar

Hello @Mariamfatimamirza 

In testing your solution, it seems to work as you are describing... could you please share how you testing the workflow's functionality? 

I used the interface designer. You can go here, click the little wand icon, select your file and open debug

gautiergodard_0-1667504412802.png

 

 

Hope this helps!

 

DataNath
17 - Castor
17 - Castor

Hey @Mariamfatimamirza, when going to the Interface Designer (Ctrl+Alt+D), you didn't have anything ticked under 'On Success - Show Results to User' and so you weren't telling Alteryx to show anything upon a successful run. After ticking the 2 browse tools, the app works as expected:

 

DataNath_0-1667504965141.png

 

DataNath_0-1667504616528.pngDataNath_1-1667504627686.png

 

On a side note, you'll notice that in my screenshots above, the 'Select an X file' that isn't part of the actively ticked radio button is hidden. This is one of the perks of the Radio Button, that you can nest other items within to keep the interface clean. To do this, we once again go to the Interface Designer and place items 'inside' one another like so:

 

Nest Radio Button items.gif

 

Amended app also attached - hope this explanation helps!

Mariamfatimamirza
7 - Meteor

Yes, when I open debug, it seems like it is disabling the other container, but I cannot see any data. I am adding a column based on the input selected, to show if it is excel or txt file. When I open the browse tool or the formula node, it says " no data available". Please see the screenshot below.

 

One other issue that I am facing is - the radio buttons do not collapse upon selecting one of them. I did select the option in radio tool to "Collapse Group When Deselected". Do you know why that would happen?

Mariamfatimamirza_0-1667504696472.png

 

Mariamfatimamirza
7 - Meteor

@DataNathThank you for such a detailed and elaborated explaination. I have a follow up question on this, if you don't mind looking into it. My logic was to allow the user to select a certain format input file (which works now per your suggestion). Once the input has been selected, I have a transformation process to configure to this input file. This process is common regardless of the input file format. Is there a way to connect/configure the selected input file with this "next steps in process"?

 

Thank you for your suggestion.

DataNath
17 - Castor
17 - Castor

Hey @Mariamfatimamirza no problem at all - always happy to help! To your follow up: Absolutely!

 

In this case, we can Union the two data streams - as you'll always be selecting one Radio button, there'll be one container disabled and one enabled and so you just simply won't get data from the disabled container. This allows us to feed everything into one downstream process as you mentioned. Here I've just made a very simple new field using the Formula tool to represent a downstream process:

 

DataNath_3-1667507394052.png

 

Now in the Interface Designer, we just need to show the result of the single browse upon completion:

 

DataNath_0-1667507320752.png

 

Now when we hit run for the two different types:

 

DataNath_1-1667507354092.pngDataNath_2-1667507369749.png

 

If we open a debug workflow we can see exactly what is going on 'under the hood' if we run this as if we're selecting an Excel file - the .txt container is disabled and therefore nothing comes out of that into the union - we just get the Excel data:

 

DataNath_4-1667507485211.png

 

Workflow attached again - hope this helps further clarify. Again, happy to answer any more queries!

Mariamfatimamirza
7 - Meteor

@DataNath- wow!! thank you so much for breaking it down to this level! This is exactly what I was looking for!!!

Mariamfatimamirza
7 - Meteor

@DataNath- Just one other question - Why can't we see data in browse and other tools when we apply radio button tool? I am able to see it only once after the workflow run is completed, but can not see it like how we generally see in other worklfows.

 

I am able to see only once as in the below screenshot soon after the workflow run is complete.

Mariamfatimamirza_0-1667520989983.png

 

But when I try to click on browse tool on my canvas, I see "no data available" (screenshot below). Is there a way to view data by clicking tools on canvas?

Mariamfatimamirza_1-1667521252206.png

 

 

gautiergodard
13 - Pulsar

Hey @Mariamfatimamirza 

Not sure if this is your question, however for analytical apps there is also another way to run the workflow, to see data passing through.

On the top right of your canvas, you'll see a little wand icon that can be used to run the workflow and ensure data is passing through.

gautiergodard_0-1667565019593.png

 

Mariamfatimamirza
7 - Meteor

@gautiergodard- Yes, I am using the wand icon to run the workflow. Once the workflow is completed, it pops up the browse tools for display. But when I click on canvas to view data on browse tools, I see "no data available"

 

Labels
Top Solution Authors