Analytic Chained App - Cross Tab to Output issue

I am encountering the following problem while trying to create a chained app -

I am trying to use the chained analytical app , everything is working fine (even getting the expected output in browse) except for while writing to the output file getting error as "The file "File Path" must contain a Name and a Value field". While I am having only 2 rows through the cross tab. The output will serve as a input to the next app drop down through external source and again getting the same error there as well. Please help me with a solution.

Cross tab Output.PNG

Workflow

Interface Tools

Chained App

Accepted answers

alexnajm

Your Drop Down in your second app is seemingly set up to reference an external source - if that's true, that file needs to have Name and Value only. You can use Alteryx to get it into that format in the first app for use in the second app.

If you are not set up that way, you can use the Crosstab as you normally would - however, it cannot be an external source then.

All comments

alexnajm

The Drop Down file being used must only have a NAME and a VALUE field - it looks like you have other fields instead!

Siddhantpattnaik

Hey, Thanks for the reply. Just wanted to understand. In normal scenario, we use cross tab so that we get the 1st row as the values for the drop down list. How do we get it simply by having the name and value field. Is it configure that way to read from external source?

Is the below screen shot the correct way of representation?

Name&Value.png

alexnajm

If you are not set up that way, you can use the Crosstab as you normally would - however, it cannot be an external source then.

Siddhantpattnaik

This is helpful. Thanks Alex.

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335