Multiple Selection box fails in chained aap

[praneshsapmm]

Dear's ,

I have AAP1 and AAP2 . 

AAP2 data is dependent on AAP1 selection as shown below . 

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

Any issue here. 

Thanks.

[AkimasaKajitani]

Hi @praneshsapmm 

Please refer WeeklyChallenge #175(Tire Size Calculator).

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

This challenge is good examination for chained app.

 

List boxes in Chained apps only work with ”ExternalSource” option.
The only way to change the choices dynamically is to use an "ExternalSource" option.

So you have to save the selection for app2 in chained app1

The first app works well because you have "executed" the workflow.

[praneshsapmm]

Hi @AkimasaKajitani  ,

Both the AAP's work well when i only check only one option . But they fail when i select multiple options . 

I think i have to try passing values by formula instead of default value . 

But not sure how to do . 

Thanks.

[cgoodman3]

When you say that App2 fails to be called after running App2 have you set this up to run in the Interface designer.

As @AkimasaKajitani suggests check out the weekly challenges with chained apps in, and there is also this interactive lesson - https://community.alteryx.com/t5/Interactive-Lessons/Chaining-Analytic-Apps/ta-p/243120

[cgoodman3]

When using a list box there is an option to create a custom list

Then you can pass that value into a filter tool to only pass specific results downstream, for example if in my main workflow I have a filter that is set to use a IN filter.

Then if I update the first app multi check box, as per the example

Then the filter tool will be updated to do this:

Which I think meets your use case?

[praneshsapmm]

Hi @cgoodman3  ,

Here are Scenario : 

When i select one option in AAP1 : 

AAp2 results are shown as below : 

Whereas i select multiple options : 

AAP2 results are not shown . 

Is it because iam passing single default value . 

Thanks

[cgoodman3]

Hi

So with mock data you've got something like this

AccountNumber,Company

0001,CompanyX

0001,CompanyY

0001,CompanyZ

0002,Companya

0002,Companyb

0002,Companyc

0003,Company1

0003,Company2

If you use that filter I showed in my earlier post then when you multi-select with say Account 0002 and 0003 it will bring through to app2 Company a,b,c,1,2.

[praneshsapmm]

Hi @cgoodman3  ,

I have this error : 

For set up : 

[cgoodman3]

I am not too familiar with the in-db tools but you need to replicate the same IN statement as I have in the non-inDB filter tool. As the action tool will replace a string but you need a way of building a string out with the list box tool which can replace multiple values.

[AkimasaKajitani]

Hi @praneshsapmm 

As he says, the SQL statements must be created in the Action tool.

You have to use "Generate Custom List" option at List Box tool, and Start text, Separator and End Text have to set as below.

" is not work so set ' at SQL Server.

At Action tool, I use the below function. "Sub-Category" is my test field, so you have to overwrite the field that you want to use.

'"Sub-Category" IN ('+[#1]+')'