Chained App not picking up fields

[wonka1234]

Hi,

I have a chained app, part 1 and part 2. 

The idea of this app is to pickup inputted files (excel) and take the fields as a drop down where one can choose what to join on..

Part 1 -

part 2 of chained app -

Columns in standard recon : First Name , Lat Name, City.

Column in standard recon 2 : First Name, Last Name  

I can run it fine like this.

However if i add the column "CITY" to my recon 2 file, this does not show up in the drop down for analytic app.

How can I properly get all my fields for the join drop down in an analytic app?

[mceleavey]

@wonka1234 ,

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.

M.

[wonka1234]

@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..

[mceleavey]

Hi @wonka1234 ,

DM me, I'm happy to jump on a call and show you.

M.

[mceleavey]

@wonka1234 ,

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.

M.

[wonka1234]

@mceleavey 

does this make sense?

PArt 1 - 

part 2 - 

think im missing the finer details.

[mceleavey]

@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. 

M.

[wonka1234]

@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

[mceleavey · Accepted solution]

@wonka1234 ,

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,

M.

[wonka1234]

would you mind building two workflows?