Radio button - prompt user to select Input File
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
- Labels:
- Input
- Interface Tools
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Hope this helps!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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:
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:
Amended app also attached - hope this explanation helps!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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:
Now in the Interface Designer, we just need to show the result of the single browse upon completion:
Now when we hit run for the two different types:
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:
Workflow attached again - hope this helps further clarify. Again, happy to answer any more queries!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@DataNath- wow!! thank you so much for breaking it down to this level! This is exactly what I was looking for!!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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"
