Dynamic Filter for an app within gallery

Hi,

I am trying so hard at this however have been quite successful.

I have a request to create an app and publish it within the gallery with the following conditions:

1. On selecting the school (dropdown preferably), the next filter would be populated with the House values associated with that school.

2. On selecting the house, the output would be all the cells as per selected filters.

This app will be posted in the Alteryx Gallery.

Any help would be highly appreciated.

Harshad

School Data.xlsx

Gallery

Apps

Dynamic Processing

Accepted answers

BenMoss

1. To create a packaged workflow/macro/app you go to options > Export Workflow

2. When publishing to the gallery you should actually publish 'App1'. During the publish process make sure you check 'App2' and 'App3' as assets during this process (they should be checked by default).

3. You will need to create a 4 tiered app, rather than 3 tiers if you add this additional layer. I've created an example for you. I also made some amendments to the previous version of the app as it was returning the right house at the end but it was regardless of the school selection.

4. I'm not sure what the purpose of the schedule is? If your hooked up to the DB then your users values will automatically be populated with the latest data when they run the application. Can you clarify what you want here?

App1.yxzp

All comments

BenMoss

Hi!

What you need is a 'chained application', here's a resource on how to create one.

https://www.thedataschool.co.uk/giorgia-umani/alteryx-chained-apps/

In essence you create two applications. The first you take your initial data stream and apply the 'school' filter, then create a list of every house value for that particular school and write it to a DB.

In your second application you then populate your dropdown with the DB output from the previously application.

You can then configure the first application to run the second application on completion; this means to your end user, there is just one application, only you know it isn't

You can populate the list of schools by making this a three part chained app.

I'll build out an example.

Ben

BenMoss

Example chained app.

App1.yxzp

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280