Creating Filter Macro

[Gauravbansal]

Hi, kindly assist as I would like to create a Filter Macro for the 2 fields Period and Location below.

would really appreciate if someone can help.

[RishiK]

@Gauravbansal can you provide more info in terms what logic you want to apply when you say filter on those 2 columns?

[Gauravbansal]

Hi Rishik,

Well there is a consolidated Invoice file wherein we need to filter Location and Period to proceed further with the working. I am looking for a Filter option that a user can filter both the feilds before running the workflow on Sandbox server.

[RishiK]

@Gauravbansal  it sounds you want to do this via an Analytic App providing options for the user to filter on those fields before the workflow or process is run.

Check this out to help you:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-build-an-App/td-p/38149

https://www.thedataschool.co.uk/marc-reid/creating-analytic-app-alteryx

https://www.theinformationlab.co.uk/2017/03/14/alteryx-mms-applications/

If you want help on how to do this, book a 30 mins slot in our Virtual Solutions Center, and we can help live:

https://community.alteryx.com/t5/Virtual-Solution-Center/tkb-p/vsc

[Qiu]

@Gauravbansal 
Can you provide a sample data set, which is not picture? 😁