Analytic Chained App - Cross Tab to Output issue

[Siddhantpattnaik]

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.

[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?

[alexnajm · Accepted solution]

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.

[Siddhantpattnaik]

This is helpful. Thanks Alex.