Error Message when running app

dgr2017

Hello,

I'm in the process of creating my first analytical app based on a workflow I've already created. The workflow runs without any issues but when I run the app, I receive the following message:

There were errors:

Cross Tab (21): The field "RespID" is not contained in the record.

Looking at Cross Tab (21), "RespID" is selected in the Group Data by these Values section so not sure where I'm going wrong. 

Just to provide some context, the app simply incorporates a File Browse and a number of List Box Interface tools. Here is the mapping of prompts to Fields if you choose to run the app:

Select the field containing unique Respondent ID: >>> RespID

Select the field containing respondent Weights: >>> WEIGHT

Select the field containing Segmentation Codes: >>> PRIZM Premier (ZIP+6) Code 

Select Question(s) of interest: >>> CQ1Grayl_1...CQ12Grayl_6

Please find both the workflow (.yxmd) and app (.yxwz) attached. I've attached the sample input data as well. Any assistance with trouble-shooting this error is greatly appreciated.

Thanks!

Dave

Question_Value_Conversion_Weighted_Counts_v2.yxmd

Question_Value_Conversion_Weighted_Counts_v2.yxwz

Survey Data.xlsx

patrick_digan

@dgr2017 This is a great start! Thanks for including the excel file, it made it much easier. First to explain the error and how I figured it out. I opened your workflow and used the interface designer debugger (View >> Interface Designer >> Test View >> Open Debug) to try and debug what the issue could be. You can then see that your select tool isn't showing what you're expecting. Instead of only selecting the fields you check, the action tool is both selecting the fields you check AND unselecting the fields you don't select. So basically the last action tool to run is only selecting your variables of interest, and unselects those respondent, weight, and segmentation variables. Since the RespID field is not flowing into your transpose tool, it throws the error you're seeing.

Here are the changes I made:

1) I replaced 3 list box interface tools with dropdowns since you only want the user to select one field (I think). Note that I also named them using the Annotation tab of each tool. For example, I renamed your respondent tool RespID:

2) I connected your file browse to the interface tools (instead of your input tool). This will allow your interface tools to show the fields from whatever file is selected in the file browse. 

3) I deleted the select tool in lieu of a dynamic rename and dynamic select. The dynamic rename is used for the Respondent, weight and segmentation. It is simply renaming whatever fields the user selects to be the standard name. For example, if the Respondent field is "field1", then it will get changed to "RespID" so that your app can process it as RespID without any errors. I use this in apps to take the field the user selects and convert it to my standard name. For the variables of interest, we can use the transposed dynamic fields. I just use a dynamic select to select only the fields that the user selects (in case they want to exclude some fields I guess). If you just want to dynamically use all the fields, you don't even need to this question as the transpose will just dynamically grab them all. Note that I like passing the interface tools by using the undocumented %Question.<<Name>>%  instead of using action tools. I find it much simpler and more straightforward. It also allows you to test it out easier.

4) I updated the Configuration >> Workflow tab throw your current field names through as test values. I set the segment variable to "PRIZM Premier (ZIP+6) Code".

5) I added a dynamic rename at the end to flip the names back to what the user selects.

6) I used the interface designer >> properties to display the browse tool.

It seems to work on my end, but let me know if I missed something! You'll want to change your input tool back to the path you had originally. I changed it to a relative path to work on my machine. 

Question_Value_Conversion_Weighted_Counts_v2.yxwz