Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
Hi Team,
Hope you are well. I need help.
Please find below the description of my problem
I am trying to develop a App where in user can enter the key word and the app can extract all the location of the files or folders with the user input keyword.
Description of the problem
For e.g. if i have a sql database with two columns one is File/Folder Name and other column is Location of the folder. In this case of the file name is Payrol and there will be a location where this file is saved.
When the user inputs "Payrol" the App should share the location of the file. I am kind of mocking it up by first reading files through my desk top and make the app search through it.
Current solution
The app is running but its giving me all the files in that folder. I want only the files related to "payrol". I have tried using conditions in App but not sure how to go about it.
Need help
How can the app select the files or folders based on the user input Keyword.
Please let me know,
Thanks,
Sri
Solved! Go to Solution.
""on point number 2). Is it possible to provide a location of a directory rather than a specific file location. ? ""
Yes (if I understand what you're asking correctly):
See the part highlighted above? If you select that part, that allows you to replace the directory location. However, you'd have to think of how to configure that part. But you do have access to change that part which is good news!
Hopefully that's useful
@sriniprad08 how to access the interface designer: click View -> Interface Designer. Then click on the little settings cog
What I meant by "Configure that part":
You can certainly replace the entire directory path
As you can see it's highlighted in blue, meaning we can access it to replace it.
Hi @BS_THE_ANALYST ,
Thank you for the all the support. Wonderful. I have couple of more questions .
Please find below if the file has multiple values and the if the user inputs multiple conditions is possible in the app to do generate the outpu1 and output2 like below.
Please let me know,
Thanks,
Sri
@sriniprad08 yes you can achieve your next request. Here, you will need to leverage a topic called Chained Apps. The reason: you need to take the results after the user filters i.e. they choose sam (therefore filtering the current data just to Sam) and then from this, make another filter choice. You could chain multiple apps for multiple filtering if you so wished.
Firstly, learn about chained apps, to understand the nuances: https://community.alteryx.com/t5/Learning-Paths/Advanced-Certification-Learning-Path/ta-p/660137#don...
Click on this lesson, and you'll learn about Chained Apps.
In brief, I've got what you require. However, I'd learn on the interactive lessons so you can tweak things yourself 😁.
For now, open Chain1:
1. Configure the Output tool to a place where you want the first filtered results to output.
Then do the same for the input file in Chain2:
2. In the Interface Designer in Chain1, go point it to Chain2:
3. In chain 2, ensure this part is enabled. It makes sure the user gets the results displayed to them.
I've attached the .yxmd files. Just run the Chain1 as an Analytic App using the wand next to the run button.
(I'm guessing something is likely to go wrong as I've missed a step when explaining it) 😂. Hopefully you get 95% of the way, and the lesson will help guide the rest.
All the best,
BS
