Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

How to find corresponding result in the dataset base on keyword search using analytic app

NatashaSuello
6 - Meteoroid

Hi, 

 

How can I search using keywords only and not necessarily need to enter the exact match word in the file?

 

Ex.

-Column A has a list of fruits.

-Column B list their colors.

-Column C has fixed generated code for each color. 

 

 

So if I enter the keyword in the text box with a question, 'Please Enter Fruit' ex. Apple, and in the Color column: red,

the output should show all results in the row (Columns A, B, C) based on the selection made.

NatashaSuello_0-1674137937198.pngNatashaSuello_1-1674137977914.png

 

 

NatashaSuello_2-1674138024407.png

 

NatashaSuello_3-1674138053456.png

 

 

Note: 

It is required to enter in question to search 1. fruit first

then 2. enter the color

 

expected result: 

NatashaSuello_4-1674138088385.png

 

attached sample data

 

Thank you. 

2 REPLIES 2
Taylor_S
8 - Asteroid

Hello! 

 

I've been tinkering with this for a bit and though I'm unsure if it can be done using a single app, I have found a way to make it possible using a series of chained apps so that after App 1 executes, the others are executed in sequence. 

App 1 is a basic filter. Using a "Contain" expression, it filters out the fruits based on whether that column contains the string entered via the textbox. This will work for plural and singular variants (i.e. Apples vs. Apple), then outputs both the filtered version of the initial flow (App1output.yxdb) and a document for App 2's listbox (Fruit list.yxdb). 

Taylor_S_0-1674155035552.png

 

App2 gives the user then the option to choose which of the available fruit values they want to use from a listbox. More than one may be selected if the option is available. This then outputs a newly filtered version of App1output.yxdb (App2output.yxdb)

Taylor_S_1-1674155333639.png

 

App 3 then takes App2Output.yxdb and goes through the same process of App 1 by allowing the user to enter a color and then outputting 2 separate files. The first being the newly filtered App2Output that accounts for both the filtered color and the fruit (App3output.yxdb) and the listbox items for app 4 (color list.yxdb). 

Taylor_S_2-1674155470096.png

 

Finally, app 4 mimics app 2 by allowing the user to select from the available color options what they want to narrow their filter down to, and finally output the results of all actions up to this point. 

Taylor_S_3-1674155555399.png

 

Taylor_S_4-1674155587809.png

 

Obviously there is a lot of room where this could be improved (for example creating error messages if a color or fruit entered via a text box does not exist within the dataset) but I hope this helps get you a little closer to your desired outcome :) I apologize I couldn't help more using a singular app. 

NatashaSuello
6 - Meteoroid

Hi Taylor, 

Thank you for these amazing solutions. App1 works for me at least. Appreciate it!

Labels