Alteryx Designer Desktop Discussions

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

List Box Tool Configuration

CamilleB
6 - Meteoroid

Hi,

 

I am trying to create an app that will allow the user to choose multiple attributes that will generate a single report from those attributes that were chosen by the user. 

 

I am at the finish line with this but got stuck in the correct formula to use. 

 

Filter Tool ConfigFilter Tool ConfigAction Tool ConfigAction Tool Config
List Box Tool ConfigList Box Tool Config

Could someone help me with the correct formula to use? There will be about 72 listings for the user to choose from. 

4 REPLIES 4
SamJHolmes
6 - Meteoroid

Hi Camile,

 

Do you think you can attach a copy of your workflow so I can dig into this a bit deeper?

 

Thanks


Sam

CamilleB
6 - Meteoroid

Hi Sam, 

 

Yes sure.

 

Please see attached.

 

I basically removed the information that was placed in the text box tool with "**Information Entered Here**" as the information was sensitive. But you will get a gist of how the workflow is, or how I am trying to get it to work.

DavidxL
9 - Comet

I think it would be easier to use the List Box in Select Tool mode and use some Transpose/Cross Tab to Join instead of Filter.

 

I've attached an example. I'm using a custom macro "Special Character Cross Tab" which is my version of "Cross Tab Real" by Ben Moss to Transpose while retaining the spaces in the column names.

CamilleB
6 - Meteoroid

Thank You!

Labels