Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Chained App not picking up fields

wonka1234
10 - Fireball

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 -

wonka1234_0-1677769674225.png

 

part 2 of chained app -

 

wonka1234_1-1677769729451.png

 

 

 

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?

 

15 REPLIES 15
wonka1234
10 - Fireball

@mceleavey 

 

think im getting closer...

 

wonka1234_0-1677786138899.png

 

 

example of name and value - 

 

wonka1234_1-1677786153976.png

 

 

workflow 2 - 

 

wonka1234_2-1677786167795.png

wonka1234_3-1677786209111.png

 

 

but getting error 

Join (71): The field "1" is missing. Compare the tool configuration with the input stream.

mceleavey
17 - Castor
17 - Castor

@wonka1234 ,

 

No, the Name field is what you are selecting.

You can't have multiple fields on one tool.

Check the example file

 

M.



Bulien

wonka1234
10 - Fireball

@mceleavey  not really sure where im going wrong here..

mceleavey
17 - Castor
17 - Castor

@wonka1234 ,

 

if you read the previous posts you have all the information.

In the last one, the file input you were using did not match the format I provided.

 

I have provided the link to learn how to use the Dropdown tool, please read that.

 

Without seeing your workflow, I don't need the data, I can't help any more. You have all the information.

The problem is how you are using the Dropdown tool.

 

M



Bulien

Tam
9 - Comet

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

wonka1234
10 - Fireball

@Tam  bleh i cant get it working

Labels