Alteryx Designer Desktop Discussions

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

Multiple Selection box fails in chained aap

praneshsapmm
8 - Asteroid

Dear's ,

 

I have AAP1 and AAP2 . 

 

AAP2 data is dependent on AAP1 selection as shown below . 

 

praneshsapmm_0-1605923883163.png

 

But when i select multiple values in AAP1 in above pic , it fails to call AAP2 . 

 

Any issue here. 

 

Thanks.

18 REPLIES 18
praneshsapmm
8 - Asteroid

Hi @AkimasaKajitani ,

 

Iam unable to open the workflow due to the Alteryx version iam using . 

 

Also i managed to change the set up in AAP1 and now it is accepting multiple values . 


What is the set up change that needs to be done for AAP2 . 

 

Is it same .

 

Thanks

AkimasaKajitani
17 - Castor
17 - Castor

Hi @praneshsapmm 

 

How do you get the values for List Box tool at APP2?
If you get the Data from Input tool's data, the attempt will fail.
Designer must run to use as yxwz once. And then Designer refresh the List Box data. So APP1 is no problem. But after it chained app2 or 3... are not work well.

 

explain.png

 

You have to use the option "External Source" at List Box after chained app. Off course you save the data for the List Box's list of chained APP2 at Chained APP1.

 

List Box setting to need at Chained APP2

AkimasaKajitani_1-1606102335544.png

 

Its format is consist of 2 fields that have "NAME" and "VALUE".

 

Sample

samplelist.png

 

 

The most good sample WF is from Weekly Challenge.

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-175-Tire-Size-Calculator/td-p/447639

 

And you can downgrade workflow version. Please refer the below URL.

https://www.theinformationlab.co.uk/2018/07/12/downgrading-alteryx-workflows/

praneshsapmm
8 - Asteroid

Hi @AkimasaKajitani ,

 

Not sure what is the issue . 

 

No out is generated from AAP2 when multiple values are selected.

 

praneshsapmm_1-1606138782553.png

 

 

praneshsapmm_0-1606138720215.png

 

praneshsapmm_2-1606138837378.png

 

Please advice

 

 

 

AkimasaKajitani
17 - Castor
17 - Castor

Hi @praneshsapmm 

 

Thank you for your screen shot.

 

Your formula is '"[CCode]" IN ('+[#1]+')', but this has problem.

[CCode] must not be enclosed in double quotations.

When [#1] is 'cat1','cat2', finally the filter tool is overwritten by "[CCode]" IN ('cat1','cat2').

 

The correct formula is the bellow.

 

'[CCode] IN ('+[#1]+')'

 

praneshsapmm
8 - Asteroid

Hi @AkimasaKajitani 

 

I have been off to work ,so couldn't reply . Will do the changes and let you know .

 

Thanks.

praneshsapmm
8 - Asteroid

Hi @AkimasaKajitani  ,

 

I tried with changes . Still has the issue of not accepting multiple inputs.

 

praneshsapmm_2-1606818127422.png

 

 

praneshsapmm_0-1606817388340.png

 

praneshsapmm_1-1606817432930.png

 

 

AkimasaKajitani
17 - Castor
17 - Castor

Hi @praneshsapmm 

 

Are there any unnecessary blanks at List Box tool?

 

AkimasaKajitani_0-1606818968768.png

 

I seem that at your screen shot there are blank at End Text box.

 

 

blank.jpg

 

Please check it.

praneshsapmm
8 - Asteroid

Hi @AkimasaKajitani  ,

 

Sure i will check this . 

 

Also can you let me know what should be the value in formula field . 

praneshsapmm_0-1606819472747.png

Thanks

AkimasaKajitani
17 - Castor
17 - Castor

Hi @praneshsapmm 

 

In Analytic APP, Filter tool setting is overwrite by Action tool at this workflow, so you can set any value that doesn't output the error.

 

Labels