Chained App not picking up fields

You need two columns in your dropdown. I've built this is an example:

When I select New York, it populates my text tool with the value, which is 1:

This is how the dropdown works from an external file.

I hope this helps,

drop-down example.yxwz

Drop-Down Example File.xlsx

All comments

you have the file on the second app as a file input, which would need to run before it could populate the dropdown. This method won't work in the chained app.

You need to output the file from the first app into the required format (rather than inputting on the second, pivoting etc.), then changing your dropdown to be "External Source":

Then select the file you output from the first app.

@mceleavey

1. I do not know what you mean output file into required format, not sure i understand this.

2. I do no t have the option to chang eto external source in my current dropdown..

see this part:

This needs to be done in the first part of the chained app, then your dropdown needs to pull in that file.

@mceleavey

does this make sense?

PArt 1 -

part 2 -

think im missing the finer details.

@wonka1234

It looks correct but without seeing your data I can't help.

Basically, the first app runs, and the second app picks up an output so the dropdown is filtered to only those related to your selection in the first.

The dropdown tool needs NAME and VALUE fields in the external file, and nothing else. Just two columns.

You can read about the dropdown tool HERE.

I would be happy to jump on a call to show you how to work this. DM me with your email address and I'll send you a link if this would suit.

@mceleavey

these are what my two files look like, I think im far off.

Name	Cool	City
John	No	London
Emily	Yes	Toronto
Henry	Yes	New York

and

Name	Cool	City	In office
John	Yes	London	Yes
Emily	Yes	Toronto	No
Henry	Yes	New York	No

You need two columns in your dropdown. I've built this is an example:

When I select New York, it populates my text tool with the value, which is 1:

This is how the dropdown works from an external file.

I hope this helps,

drop-down example.yxwz

Drop-Down Example File.xlsx

Tam

@wonka1234 might be worth a visit to: Chaining Analytic Apps - Alteryx Community this should reinforce @mceleavey points pay special attention to the second app drop down.