Alteryx Designer Desktop Discussions

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

Action, Text box, and Filter tools together

RobMotiwalla
7 - Meteor

Hello All -- 

 

I feel like this should be very simple to do, yet I cannot make it work. I am reading in a bunch of files, and I am looking to filter on only those with SKUs that the user inputs.

 

The file is a billing file, so there are columns for dates, products, invoice numbers, UPCs, SKUs, etc. All that I am trying to do is filter all of the rows that contain a specific SKU that is entered by the user.

 

Text Box

text box 2022-09-23 133741.png

 

Action Tool

Action 2022-09-23 133931.png

 

 

Data into filter

Screenshot 2022-09-23 134237.png

Can you please assist in how I can have the user input a SKU using the text box, and then only those rows of data that have that SKU to proceed through the True side of the filter tool? Any help is appreciated!

 

Also, if you can help with a filter by date action tool as well, that would be helpful for my next step.

3 REPLIES 3
Felipe_Ribeir0
16 - Nebula

Hi @RobMotiwalla 

 

Please take a look at the attached example, the setup is almost like your case. The problem that i saw at your pictures is that you are trying to use control tools without setting up the macro. You must save the control tools and the macro components (you need to convert the input into a macro input) as a new workflow and embed it into your main workflow.

Felipe_Ribeir0_0-1663955635452.png

Felipe_Ribeir0_1-1663955717824.png

 

Maybe it is a good idea to take a look at the macro iterative lessons Interactive Lessons - Alteryx Community

 

If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

 

Thanks.

Emmanuel_G
13 - Pulsar

@RobMotiwalla 

 

Once you have finished your tests with data entries, change your data input to macro input tool and try again. Also, change the output tool to macro output tool.

 

Personally, other than that, I don't see any anomaly in your macro configuration relative to what you want to do.

 

And keep in mind that the next data that will enter the analytical application or the macro must have the same format as that of the input macro tool.

 

You can change the macro extension to analytical application by clicking on the radio button in your canvas workflow window as shown below.

 

Emmanuel_G_0-1663956246327.png

 

 

Let me know if there is any issue and do not hesitate to mark this answer as solution if it helped.

Felipe_Ribeir0
16 - Nebula

Hi @RobMotiwalla 

 

It worked?  

Labels